VIEW: APPS.ZX_SYNC_HDR_INPUT_V

Source

View Text - Preformatted

SELECT
   zldf.internal_organization_id,
   ztppo.legal_entity_number,
   ztppo.establishment_number,
   zldf.event_class_mapping_id,
   zldf.trx_id,
   ztppo.application_short_name,
   zldf.tax_event_type_code,
   zldf.trx_number,
   zldf.trx_description,
   zldf.doc_seq_value,
   zldf.trx_due_date,
   zpshea.HEADER_EXT_VARCHAR_ATTRIBUTE1,
   zpshea.HEADER_EXT_VARCHAR_ATTRIBUTE2,
   zpshea.HEADER_EXT_VARCHAR_ATTRIBUTE3,
   zpshea.HEADER_EXT_VARCHAR_ATTRIBUTE4,
   zpshea.HEADER_EXT_VARCHAR_ATTRIBUTE5,
   zpshea.HEADER_EXT_VARCHAR_ATTRIBUTE6,
   zpshea.HEADER_EXT_VARCHAR_ATTRIBUTE7,
   zpshea.HEADER_EXT_VARCHAR_ATTRIBUTE8,
   zpshea.HEADER_EXT_VARCHAR_ATTRIBUTE9,
   zpshea.HEADER_EXT_VARCHAR_ATTRIBUTE10,
   zpshea.HEADER_EXT_VARCHAR_ATTRIBUTE11,
   zpshea.HEADER_EXT_VARCHAR_ATTRIBUTE12,
   zpshea.HEADER_EXT_VARCHAR_ATTRIBUTE13,
   zpshea.HEADER_EXT_VARCHAR_ATTRIBUTE14,
   zpshea.HEADER_EXT_VARCHAR_ATTRIBUTE15,
   zpshea.HEADER_EXT_VARCHAR_ATTRIBUTE16,
   zpshea.HEADER_EXT_VARCHAR_ATTRIBUTE17,
   zpshea.HEADER_EXT_VARCHAR_ATTRIBUTE18,
   zpshea.HEADER_EXT_VARCHAR_ATTRIBUTE19,
   zpshea.HEADER_EXT_VARCHAR_ATTRIBUTE20,
   zpshea.HEADER_EXT_VARCHAR_ATTRIBUTE21,
   zpshea.HEADER_EXT_VARCHAR_ATTRIBUTE22,
   zpshea.HEADER_EXT_VARCHAR_ATTRIBUTE23,
   zpshea.HEADER_EXT_VARCHAR_ATTRIBUTE24,
   zpshea.HEADER_EXT_VARCHAR_ATTRIBUTE25,
   zpshea.HEADER_EXT_VARCHAR_ATTRIBUTE26,
   zpshea.HEADER_EXT_VARCHAR_ATTRIBUTE27,
   zpshea.HEADER_EXT_VARCHAR_ATTRIBUTE28,
   zpshea.HEADER_EXT_VARCHAR_ATTRIBUTE29,
   zpshea.HEADER_EXT_VARCHAR_ATTRIBUTE30,
   zpshea.header_ext_number_attribute1,
   zpshea.header_ext_number_attribute2,
   zpshea.header_ext_number_attribute3,
   zpshea.header_ext_number_attribute4,
   zpshea.header_ext_number_attribute5,
   zpshea.header_ext_number_attribute6,
   zpshea.header_ext_number_attribute7,
   zpshea.header_ext_number_attribute8,
   zpshea.header_ext_number_attribute9,
   zpshea.header_ext_number_attribute10,
   zpshea.header_ext_date_attribute1,
   zpshea.header_ext_date_attribute2,
   zpshea.header_ext_date_attribute3,
   zpshea.header_ext_date_attribute4,
   zpshea.header_ext_date_attribute5
FROM
   zx_lines_det_factors zldf,
   zx_trx_pre_proc_options_gt ztppo,
   zx_prvdr_hdr_extns_gt zpshea
WHERE
   zldf.application_id = ztppo.application_id
   AND zldf.entity_code = ztppo.entity_code
   AND zldf.event_class_code = ztppo.event_class_code
   AND zldf.trx_id = ztppo.trx_id
   AND zpshea.application_id = ztppo.application_id /*header level extensible attributes */
   AND zpshea.entity_code = ztppo.entity_code
   AND zpshea.event_class_code = ztppo.event_class_code
   AND zpshea.trx_id = ztppo.trx_id
   AND zpshea.provider_id = ztppo.tax_provider_id
   AND zpshea.tax_regime_code = ztppo.tax_regime_code
   and rownum=1

View Text - HTML Formatted

SELECT ZLDF.INTERNAL_ORGANIZATION_ID
, ZTPPO.LEGAL_ENTITY_NUMBER
, ZTPPO.ESTABLISHMENT_NUMBER
, ZLDF.EVENT_CLASS_MAPPING_ID
, ZLDF.TRX_ID
, ZTPPO.APPLICATION_SHORT_NAME
, ZLDF.TAX_EVENT_TYPE_CODE
, ZLDF.TRX_NUMBER
, ZLDF.TRX_DESCRIPTION
, ZLDF.DOC_SEQ_VALUE
, ZLDF.TRX_DUE_DATE
, ZPSHEA.HEADER_EXT_VARCHAR_ATTRIBUTE1
, ZPSHEA.HEADER_EXT_VARCHAR_ATTRIBUTE2
, ZPSHEA.HEADER_EXT_VARCHAR_ATTRIBUTE3
, ZPSHEA.HEADER_EXT_VARCHAR_ATTRIBUTE4
, ZPSHEA.HEADER_EXT_VARCHAR_ATTRIBUTE5
, ZPSHEA.HEADER_EXT_VARCHAR_ATTRIBUTE6
, ZPSHEA.HEADER_EXT_VARCHAR_ATTRIBUTE7
, ZPSHEA.HEADER_EXT_VARCHAR_ATTRIBUTE8
, ZPSHEA.HEADER_EXT_VARCHAR_ATTRIBUTE9
, ZPSHEA.HEADER_EXT_VARCHAR_ATTRIBUTE10
, ZPSHEA.HEADER_EXT_VARCHAR_ATTRIBUTE11
, ZPSHEA.HEADER_EXT_VARCHAR_ATTRIBUTE12
, ZPSHEA.HEADER_EXT_VARCHAR_ATTRIBUTE13
, ZPSHEA.HEADER_EXT_VARCHAR_ATTRIBUTE14
, ZPSHEA.HEADER_EXT_VARCHAR_ATTRIBUTE15
, ZPSHEA.HEADER_EXT_VARCHAR_ATTRIBUTE16
, ZPSHEA.HEADER_EXT_VARCHAR_ATTRIBUTE17
, ZPSHEA.HEADER_EXT_VARCHAR_ATTRIBUTE18
, ZPSHEA.HEADER_EXT_VARCHAR_ATTRIBUTE19
, ZPSHEA.HEADER_EXT_VARCHAR_ATTRIBUTE20
, ZPSHEA.HEADER_EXT_VARCHAR_ATTRIBUTE21
, ZPSHEA.HEADER_EXT_VARCHAR_ATTRIBUTE22
, ZPSHEA.HEADER_EXT_VARCHAR_ATTRIBUTE23
, ZPSHEA.HEADER_EXT_VARCHAR_ATTRIBUTE24
, ZPSHEA.HEADER_EXT_VARCHAR_ATTRIBUTE25
, ZPSHEA.HEADER_EXT_VARCHAR_ATTRIBUTE26
, ZPSHEA.HEADER_EXT_VARCHAR_ATTRIBUTE27
, ZPSHEA.HEADER_EXT_VARCHAR_ATTRIBUTE28
, ZPSHEA.HEADER_EXT_VARCHAR_ATTRIBUTE29
, ZPSHEA.HEADER_EXT_VARCHAR_ATTRIBUTE30
, ZPSHEA.HEADER_EXT_NUMBER_ATTRIBUTE1
, ZPSHEA.HEADER_EXT_NUMBER_ATTRIBUTE2
, ZPSHEA.HEADER_EXT_NUMBER_ATTRIBUTE3
, ZPSHEA.HEADER_EXT_NUMBER_ATTRIBUTE4
, ZPSHEA.HEADER_EXT_NUMBER_ATTRIBUTE5
, ZPSHEA.HEADER_EXT_NUMBER_ATTRIBUTE6
, ZPSHEA.HEADER_EXT_NUMBER_ATTRIBUTE7
, ZPSHEA.HEADER_EXT_NUMBER_ATTRIBUTE8
, ZPSHEA.HEADER_EXT_NUMBER_ATTRIBUTE9
, ZPSHEA.HEADER_EXT_NUMBER_ATTRIBUTE10
, ZPSHEA.HEADER_EXT_DATE_ATTRIBUTE1
, ZPSHEA.HEADER_EXT_DATE_ATTRIBUTE2
, ZPSHEA.HEADER_EXT_DATE_ATTRIBUTE3
, ZPSHEA.HEADER_EXT_DATE_ATTRIBUTE4
, ZPSHEA.HEADER_EXT_DATE_ATTRIBUTE5 FROM ZX_LINES_DET_FACTORS ZLDF
, ZX_TRX_PRE_PROC_OPTIONS_GT ZTPPO
, ZX_PRVDR_HDR_EXTNS_GT ZPSHEA WHERE ZLDF.APPLICATION_ID = ZTPPO.APPLICATION_ID
AND ZLDF.ENTITY_CODE = ZTPPO.ENTITY_CODE
AND ZLDF.EVENT_CLASS_CODE = ZTPPO.EVENT_CLASS_CODE
AND ZLDF.TRX_ID = ZTPPO.TRX_ID
AND ZPSHEA.APPLICATION_ID = ZTPPO.APPLICATION_ID /*HEADER LEVEL EXTENSIBLE ATTRIBUTES */
AND ZPSHEA.ENTITY_CODE = ZTPPO.ENTITY_CODE
AND ZPSHEA.EVENT_CLASS_CODE = ZTPPO.EVENT_CLASS_CODE
AND ZPSHEA.TRX_ID = ZTPPO.TRX_ID
AND ZPSHEA.PROVIDER_ID = ZTPPO.TAX_PROVIDER_ID
AND ZPSHEA.TAX_REGIME_CODE = ZTPPO.TAX_REGIME_CODE
AND ROWNUM=1