ZX_AP_DEF_TAX_EXTRACT_V

Details

• Schema: FUSION

• Object owner: FND

• Object type: VIEW

Columns

Name
REC_NREC_TAX_DIST_ID SUMMARY_TAX_LINE_ID TAX_LINE_ID TRX_LINE_DIST_ID RECOVERABLE_FLAG DEF_REC_SETTLEMENT_OPTION_CODE TAX_ACCOUNT_CCID ORG_ID LEDGER_ID TAX_POINT_BASIS

Query

SQL_Statement

SELECT REC_NREC_TAX_DIST_ID REC_NREC_TAX_DIST_ID, SUMMARY_TAX_LINE_ID SUMMARY_TAX_LINE_ID, TAX_LINE_ID TAX_LINE_ID, TRX_LINE_DIST_ID TRX_LINE_DIST_ID, RECOVERABLE_FLAG RECOVERABLE_FLAG, DEF_REC_SETTLEMENT_OPTION_CODE DEF_REC_SETTLEMENT_OPTION_CODE, TAX_ACCOUNT_CCID, INTERNAL_ORGANIZATION_ID ORG_ID, LEDGER_ID LEDGER_ID, TAX_POINT_BASIS TAX_POINT_BASIS FROM ( select decode( tax_point_basis,'PAYMENT', tax_account_ccid, NULL) tax_account_ccid, rec_nrec_tax_dist_id, SUMMARY_TAX_LINE_ID, TAX_LINE_ID, TRX_LINE_DIST_ID, RECOVERABLE_FLAG, DEF_REC_SETTLEMENT_OPTION_CODE, INTERNAL_ORGANIZATION_ID, LEDGER_ID, tax_point_basis, row_number() over (partition by rec_nrec_tax_dist_id order by hier, INTERNAL_ORGANIZATION_ID NULLS LAST) as first_row from (select accounts.TAX_ACCOUNT_CCID, d1.rec_nrec_tax_dist_id, d1.tax_point_basis, d1.SUMMARY_TAX_LINE_ID, d1.TAX_LINE_ID, d1.TRX_LINE_DIST_ID, d1.RECOVERABLE_FLAG, d1.DEF_REC_SETTLEMENT_OPTION_CODE, d1.LEDGER_ID, decode(accounts.TAX_ACCOUNT_ENTITY_ID, d1.ACCOUNT_SOURCE_TAX_RATE_ID, 1, d1.recovery_rate_id, 2, 3) as hier, accounts.INTERNAL_ORGANIZATION_ID from zx_rec_nrec_dist d1 left outer join zx_accounts ACCOUNTS on (accounts.TAX_ACCOUNT_ENTITY_ID in (d1.ACCOUNT_SOURCE_TAX_RATE_ID, d1.recovery_rate_id, d1.TAX_RATE_ID) AND accounts.TAX_ACCOUNT_ENTITY_CODE = 'RATES' AND (accounts.INTERNAL_ORGANIZATION_ID = d1.INTERNAL_ORGANIZATION_ID or accounts.INTERNAL_ORGANIZATION_ID is null) AND accounts.LEDGER_ID = d1.LEDGER_ID) ) ) WHERE first_row = 1