VIEW: APPS.ZX_AP_DEF_TAX_EXTRACT_V

Source

View Text - Preformatted

SELECT
   tax_dist.REC_NREC_TAX_DIST_ID             REC_NREC_TAX_DIST_ID,
   tax_dist.SUMMARY_TAX_LINE_ID              SUMMARY_TAX_LINE_ID,
   tax_dist.TAX_LINE_ID                      TAX_LINE_ID,
   tax_dist.TRX_LINE_DIST_ID                 TRX_LINE_DIST_ID,
   tax_dist.RECOVERABLE_FLAG                 RECOVERABLE_FLAG,
   tax_dist.DEF_REC_SETTLEMENT_OPTION_CODE   DEF_REC_SETTLEMENT_OPTION_CODE,
   decode(tax_dist.DEF_REC_SETTLEMENT_OPTION_CODE,
       'DEFERRED', accounts.TAX_ACCOUNT_CCID, NULL)
                                             TAX_ACCOUNT_CCID,
   accounts.INTERNAL_ORGANIZATION_ID         ORG_ID,
   accounts.LEDGER_ID 			     LEDGER_ID
FROM
   zx_rec_nrec_dist  tax_dist LEFT OUTER JOIN zx_accounts ACCOUNTS
ON (accounts.TAX_ACCOUNT_ENTITY_ID = nvl(tax_dist.ACCOUNT_SOURCE_TAX_RATE_ID, tax_dist.TAX_RATE_ID)
AND accounts.TAX_ACCOUNT_ENTITY_CODE = 'RATES'
AND accounts.INTERNAL_ORGANIZATION_ID = tax_dist.INTERNAL_ORGANIZATION_ID
AND accounts.LEDGER_ID = tax_dist.LEDGER_ID
    )
   

View Text - HTML Formatted

SELECT TAX_DIST.REC_NREC_TAX_DIST_ID REC_NREC_TAX_DIST_ID
, TAX_DIST.SUMMARY_TAX_LINE_ID SUMMARY_TAX_LINE_ID
, TAX_DIST.TAX_LINE_ID TAX_LINE_ID
, TAX_DIST.TRX_LINE_DIST_ID TRX_LINE_DIST_ID
, TAX_DIST.RECOVERABLE_FLAG RECOVERABLE_FLAG
, TAX_DIST.DEF_REC_SETTLEMENT_OPTION_CODE DEF_REC_SETTLEMENT_OPTION_CODE
, DECODE(TAX_DIST.DEF_REC_SETTLEMENT_OPTION_CODE
, 'DEFERRED'
, ACCOUNTS.TAX_ACCOUNT_CCID
, NULL) TAX_ACCOUNT_CCID
, ACCOUNTS.INTERNAL_ORGANIZATION_ID ORG_ID
, ACCOUNTS.LEDGER_ID LEDGER_ID FROM ZX_REC_NREC_DIST TAX_DIST LEFT OUTER JOIN ZX_ACCOUNTS ACCOUNTS ON (ACCOUNTS.TAX_ACCOUNT_ENTITY_ID = NVL(TAX_DIST.ACCOUNT_SOURCE_TAX_RATE_ID
, TAX_DIST.TAX_RATE_ID) AND ACCOUNTS.TAX_ACCOUNT_ENTITY_CODE = 'RATES' AND ACCOUNTS.INTERNAL_ORGANIZATION_ID = TAX_DIST.INTERNAL_ORGANIZATION_ID AND ACCOUNTS.LEDGER_ID = TAX_DIST.LEDGER_ID )