VIEW: APPS.ZX_USER_PROC_HDR_INPUT_V

Source

View Text - Preformatted

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_ID  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    

   

View Text - HTML Formatted

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_ID 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