[Home] [Help]
View: 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