View: ZX_USER_PROC_LINE_INPUT_V

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

View Text

SELECT ZX_DET_FACT.INTERNAL_ORGANIZATION_ID INTERNAL_ORGANIZATION_ID
, ZX_DET_FACT.APPLICATION_ID APPLICATION_ID
, ZX_DET_FACT.ENTITY_CODE ENTITY_CODE
, ZX_DET_FACT.EVENT_CLASS_CODE EVENT_CLASS_CODE
, ZX_DET_FACT.TRX_ID TRX_ID
, ZX_PRE_REC_OPT.TAX_PROVIDER_ID TAX_PROVIDER_ID
, ZX_PRE_REC_OPT.TAX_REGIME_CODE TAX_REGIME_CODE
, ZX_DET_FACT.TRX_LEVEL_TYPE TRX_LINE_TYPE
, ZX_DET_FACT.TRX_LINE_ID TRX_LINE_ID
, ZX_DET_FACT.PRODUCT_ID PRODUCT_ID
, ZX_DET_FACT.PRODUCT_ORG_ID PRODUCT_ORG_ID
, ZX_DET_FACT.EXEMPT_CERTIFICATE_NUMBER EXEMPT_CERTIFICATE_NUMBER
, ZX_DET_FACT.EXEMPT_REASON EXEMPT_REASON_CODE
, ZX_DET_FACT.EXEMPTION_CONTROL_FLAG EXEMPTION_CONTROL_FLAG
, ZX_DET_FACT.SHIP_FROM_PARTY_TAX_PROF_ID SHIP_FROM_PARTY_TAX_PROFILE_ID
, ZX_DET_FACT.SHIP_TO_SITE_TAX_PROF_ID SHIP_TO_SITE_TAX_PROF_ID
, ZX_DET_FACT.SHIP_TO_PARTY_TAX_PROF_ID SHIP_TO_PARTY_TAX_PROFILE_ID
, ZX_DET_FACT.SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID
, ZX_DET_FACT.BILL_TO_CUST_ACCT_SITE_USE_ID BILL_TO_CUST_ACCT_SITE_USE_ID
, ZX_DET_FACT.BILL_TO_SITE_TAX_PROF_ID BILL_TO_SITE_TAX_PROF_ID
, ZX_DET_FACT.BILL_TO_PARTY_TAX_PROF_ID BILL_TO_PARTY_TAX_PROF_ID
, ZX_DET_FACT.BILL_TO_LOCATION_ID BILL_TO_LOCATION_ID
, ZX_DET_FACT.LINE_LEVEL_ACTION LINE_LEVEL_ACTION
, ZX_DET_FACT.ADJUSTED_DOC_TRX_ID ADJUSTED_DOC_TRX_ID
, ZX_DET_FACT.LINE_AMT LINE_AMT
, ZX_DET_FACT.TRADING_HQ_SITE_TAX_PROF_ID TRADING_HQ_SITE_TAX_PROF_ID
, ZX_DET_FACT.TRADING_HQ_PARTY_TAX_PROF_ID TRADING_HQ_PARTY_TAX_PROF_ID
, ZX_DET_FACT.BILL_THIRD_PTY_ACCT_ID BILL_THIRD_PTY_ACCT_ID
, ZX_DET_FACT.ADJUSTED_DOC_APPLICATION_ID ADJUSTED_DOC_APPLICATION_ID
, ZX_DET_FACT.ADJUSTED_DOC_ENTITY_CODE ADJUSTED_DOC_ENTITY_CODE
, ZX_DET_FACT.ADJUSTED_DOC_EVENT_CLASS_CODE ADJUSTED_DOC_EVENT_CLASS_CODE
, ZX_DET_FACT.ADJUSTED_DOC_TRX_ID ADJUSTED_DOC_TRX_LINE_ID
, ZX_DET_FACT.RECEIVABLES_TRX_TYPE_ID RECEIVABLES_TRX_TYPE_ID FROM ZX_LINES_DET_FACTORS ZX_DET_FACT
, ZX_TRX_PRE_PROC_OPTIONS_GT ZX_PRE_REC_OPT WHERE ZX_DET_FACT.INTERNAL_ORGANIZATION_ID = ZX_PRE_REC_OPT.INTERNAL_ORGANIZATION_ID AND ZX_DET_FACT.APPLICATION_ID = ZX_PRE_REC_OPT.APPLICATION_ID AND ZX_DET_FACT.EVENT_CLASS_CODE = ZX_PRE_REC_OPT.EVENT_CLASS_CODE AND ZX_DET_FACT.ENTITY_CODE = ZX_PRE_REC_OPT.ENTITY_CODE AND ZX_DET_FACT.TRX_ID = ZX_PRE_REC_OPT.TRX_ID