ZX_USER_PROC_LINE_INPUT

Details

Schema: FUSION
Object owner: FND
Object type: VIEW

Columns

Name
INTERNAL_ORGANIZATION_ID APPLICATION_ID ENTITY_CODE EVENT_CLASS_CODE TRX_ID TAX_PROVIDER_ID TAX_REGIME_CODE TRX_LINE_TYPE TRX_LINE_ID PRODUCT_ID PRODUCT_ORG_ID EXEMPT_CERTIFICATE_NUMBER EXEMPT_REASON_CODE EXEMPTION_CONTROL_FLAG SHIP_FROM_PARTY_TAX_PROFILE_ID SHIP_TO_SITE_TAX_PROF_ID SHIP_TO_PARTY_TAX_PROFILE_ID SHIP_TO_LOCATION_ID BILL_TO_CUST_ACCT_SITE_USE_ID BILL_TO_SITE_TAX_PROF_ID BILL_TO_PARTY_TAX_PROF_ID BILL_TO_LOCATION_ID LINE_LEVEL_ACTION ADJUSTED_DOC_TRX_ID LINE_AMT TRADING_HQ_SITE_TAX_PROF_ID TRADING_HQ_PARTY_TAX_PROF_ID BILL_THIRD_PTY_ACCT_ID ADJUSTED_DOC_APPLICATION_ID ADJUSTED_DOC_ENTITY_CODE ADJUSTED_DOC_EVENT_CLASS_CODE ADJUSTED_DOC_TRX_LINE_ID RECEIVABLES_TRX_TYPE_SEQ_ID

Name

INTERNAL_ORGANIZATION_ID

APPLICATION_ID

ENTITY_CODE

EVENT_CLASS_CODE

TRX_ID

TAX_PROVIDER_ID

TAX_REGIME_CODE

TRX_LINE_TYPE

TRX_LINE_ID

PRODUCT_ID

PRODUCT_ORG_ID

EXEMPT_CERTIFICATE_NUMBER

EXEMPT_REASON_CODE

EXEMPTION_CONTROL_FLAG

SHIP_FROM_PARTY_TAX_PROFILE_ID

SHIP_TO_SITE_TAX_PROF_ID

SHIP_TO_PARTY_TAX_PROFILE_ID

SHIP_TO_LOCATION_ID

BILL_TO_CUST_ACCT_SITE_USE_ID

BILL_TO_SITE_TAX_PROF_ID

BILL_TO_PARTY_TAX_PROF_ID

BILL_TO_LOCATION_ID

LINE_LEVEL_ACTION

ADJUSTED_DOC_TRX_ID

LINE_AMT

TRADING_HQ_SITE_TAX_PROF_ID

TRADING_HQ_PARTY_TAX_PROF_ID

BILL_THIRD_PTY_ACCT_ID

ADJUSTED_DOC_APPLICATION_ID

ADJUSTED_DOC_ENTITY_CODE

ADJUSTED_DOC_EVENT_CLASS_CODE

ADJUSTED_DOC_TRX_LINE_ID

RECEIVABLES_TRX_TYPE_SEQ_ID

Query

SQL_Statement
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_SEQ_ID RECEIVABLES_TRX_TYPE_SEQ_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

SQL_Statement

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_SEQ_ID RECEIVABLES_TRX_TYPE_SEQ_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