View: ZX_IMPORT_TAX_LINES_INPUT_V

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

View Text

SELECT /*+ LEADING (ZTPPO) INDEX(ZDTL ZX_DETAIL_TAX_LINES_GT_U1) */ ZTPPO.EVNT_CLS_MAPPING_ID
, ZDTL.TRX_ID
, ZDTL.TRX_LINE_ID
, ZDTL.TRX_LEVEL_TYPE
, ZDTL.TAX_REGIME_CODE
, ZDTL.TAX
, ZDTL.PLACE_OF_SUPPLY_TYPE_CODE
, ZDTL.TAX_JURISDICTION_CODE
, ZDTL.TAX_CURRENCY_CODE
, ZDTL.TAX_AMT
, ZDTL.TAX_AMT_TAX_CURR
, ZDTL.TAX_RATE
, ZDTL.TAXABLE_AMT
, ZDTL.EXEMPT_RATE_MODIFIER
, ZDTL.EXEMPT_REASON
, ZDTL.TAX_ONLY_LINE_FLAG
, ZDTL.TAX_AMT_INCLUDED_FLAG
, ZDTL.SELF_ASSESSED_FLAG
, ZDTL.OVERRIDDEN_FLAG
, ZDTL.LAST_MANUAL_ENTRY
, ZDTL.MANUALLY_ENTERED_FLAG
, ZDTL.TAX_REGISTRATION_NUMBER FROM ZX_DETAIL_TAX_LINES_GT ZDTL
, ZX_TRX_PRE_PROC_OPTIONS_GT ZTPPO WHERE ZDTL.APPLICATION_ID = ZTPPO.APPLICATION_ID
AND ZDTL.ENTITY_CODE = ZTPPO.ENTITY_CODE
AND ZDTL.EVENT_CLASS_CODE = ZTPPO.EVENT_CLASS_CODE
AND ZDTL.TRX_ID = ZTPPO.TRX_ID
AND ZDTL.TAX_REGIME_CODE = ZTPPO.TAX_REGIME_CODE
AND ZDTL.TAX_PROVIDER_ID = ZTPPO.TAX_PROVIDER_ID
AND ZTPPO.RECORD_FOR_PARTNERS_FLAG = 'Y'
AND ZTPPO.QUOTE_FLAG = 'N'