eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: ZX_AP_DEF_TAX_EXTRACT_V

Product:	FND - Application Object Library
Description:
Implementation/DBA Data:	APPS.ZX_AP_DEF_TAX_EXTRACT_V

View Text

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 )