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