1. Tables and Views for Financials
  2. ZX_USER_PROC_HDR_INPUT_V

ZX_USER_PROC_HDR_INPUT_V

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_DATE

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_DATE Trx_Date,

ZX_DET_FACT.RECEIVABLES_TRX_TYPE_SEQ_ID 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