Tuesday, October 31, 2017

Oracle E-Business Tax New/Changed Tables/Views in Oracle Apps R12

Changed Tables:-


Table Name
Feature Area
Brief Description of Change
AP_TAX_CODES_ALL
Oracle Payables Taxes
This table is now used to store only withholding tax codes
AR_VAT_TAX_ALL_B
Oracle Receivables Taxes
This table is now used only by Latin Tax Engine.
  

Obsolete Tables:-


Table Name
Feature Area
AP_TAX_RECVRY_RATES_ALL
Oracle Payables Taxes
AP_TAX_RECVRY_RULES_ALL
Oracle Payables Taxes
AR_TAX_EXTRACT_DCL_ITF
Tax Reporting Ledger
AR_TAX_EXTR_SUB_AP_EXT
Tax Reporting Ledger
AR_TAX_EXTR_SUB_AR_EXT
Tax Reporting Ledger
AR_TAX_EXTRACT_SUB_ITF
Tax Reporting Ledger
AR_TAX_EXTRACT_MATRIX_ITF
Tax Reporting Ledger
AR_TAX_EXTR_SUB_COM_EXT
Tax Reporting Ledger
AR_LOCATION_COMBINATIONS
Oracle Receivables Taxes
AR_LOCATION_RATES
Oracle Receivables Taxes
AR_LOCATION_VALUES
Oracle Receivables Taxes
AR_SALES_TAX
Oracle Receivables Taxes
AR_SALES_TAX_REP_ITF
Oracle Receivables Taxes
AR_TAX_CONDITION_ACTIONS_ALL
Oracle Receivables Taxes
AR_TAX_CONDITION_LINES_ALL
Oracle Receivables Taxes
AR_TAX_CONDTIONS_ALL
Oracle Receivables Taxes
GL_TAX_OPTIONS
Oracle General Ledger Taxes
GL_TAX_OPTION_ACCOUNTS
Oracle General Ledger Taxes
  

Changed Views:-

View Name
Feature Area
Brief Description of Change
GL_TAX_CODES_V
Oracle General Ledger Taxes
This view is modified to return information from the new tax configuration tables of Oracle E-Business Tax.


Obsolete Views:-

View Name
Feature Area
AP_TAX_RECVRY_RULES
Oracle Payables Taxes
AP_TAX_RECVRY_RATES
Oracle Payables Taxes
AP_TAX_CODES_NAMES_V
Oracle Payables Taxes
AP_TAX_CODES_V
Oracle Payables Taxes
AP_TAX_LINES_SUMMARY_V
Oracle Payables Taxes
AP_TAX_CODES_VAL_V
Oracle Payables Taxes
AP_TAX_CODES_TN_V
Oracle Payables Taxes
AP_TAX_CODES_ACTIVE_V
Oracle Payables Taxes
AR_TAX_EXTRACT_ITF_V
Tax Reporting Ledger
TAX_LINES_DELETE_V_V
Oracle Receivables Taxes
TAX_LINES_INVOICE_IMPORT_V
Oracle Receivables Taxes
TAX_LINES_DELETE_V
Oracle Receivables Taxes
TAX_LINES_INVOICE_IMPORT_V_A
Oracle Receivables Taxes
TAX_LINES_DELETE_V_A
Oracle Receivables Taxes
TAX_LINES_INQUIRY_V
Oracle Receivables Taxes
TAX_ADJUSTMENTS_V
Oracle Receivables Taxes
OE_TAX_LINES_SUMMARY_V_V
Oracle Receivables Taxes
TAX_LINES_CM_V_A
Oracle Receivables Taxes
AR_DEFAULT_TAX_CODE_V
Oracle Receivables Taxes
AR_CM_DIST_TAX_L_V
Oracle Receivables Taxes
AR_CM_DIST_TAX_L_VL
Oracle Receivables Taxes
AR_CM_TAX_L_V
Oracle Receivables Taxes
TAX_ADJUSTMENTS_V_V
Oracle Receivables Taxes
TAX_LINES_RECREATE_V
Oracle Receivables Taxes
TAX_LINES_CREATE_V_A
Oracle Receivables Taxes
TAX_LINES_RECURR_INVOICE_V
Oracle Receivables Taxes
TAX_LINES_RECURR_INVOICE_V_A
Oracle Receivables Taxes
TAX_LINES_RMA_IMPORT_V_V
Oracle Receivables Taxes
TAX_LINES_CM_V
Oracle Receivables Taxes
TAX_LINES_CREATE_V_V
Oracle Receivables Taxes
AR_TAX_L_V
Oracle Receivables Taxes
AR_CM_TAX_L_VL
Oracle Receivables Taxes
OE_TAX_LINES_SUMMARY_V_A
Oracle Receivables Taxes
TAX_LINES_CREATE_V
Oracle Receivables Taxes
TAX_ADJUSTMENTS_V_A
Oracle Receivables Taxes
TAX_LINES_RMA_IMPORT_V
Oracle Receivables Taxes
TAX_LINES_INVOICE_IMPORT_V_V
Oracle Receivables Taxes
TAX_LINES_CM_V_V
Oracle Receivables Taxes
TAX_LINES_RMA_IMPORT_V_A
Oracle Receivables Taxes
TAX_LINES_RECURR_INVOICE_V_V
Oracle Receivables Taxes
TAX_LINES_ENGINE_REVERSE_V
Oracle Receivables Taxes
AR_TAX_L_VL
Oracle Receivables Taxes
AR_DIST_TAX_L_VL
Oracle Receivables Taxes
 


Query To Fetch AP Invoice Details From SO Number(Doc ID 2949013.1)

SELECT dh.source_order_number       ,df.source_line_number as so_line_number   ,df.fulfill_line_number    ,ddr.doc_user_key as po_number...