1. Tables and Views for Financials
  2. ZX_SYNC_HDR_INPUT_V

ZX_SYNC_HDR_INPUT_V

Details

  • Schema: FUSION

  • Object owner: FND

  • Object type: VIEW

Columns

Name

INTERNAL_ORGANIZATION_ID

LEGAL_ENTITY_NUMBER

ESTABLISHMENT_NUMBER

DOCUMENT_TYPE_ID

TRANSACTION_ID

APPLICATION_CODE

DOCUMENT_LEVEL_ACTION

TRANSACTION_NUMBER

TRANSACTION_DESCRIPTION

DOCUMENT_SEQUENCE_VALUE

TRANSACTION_DUE_DATE

HEADER_CHAR1

HEADER_CHAR2

HEADER_CHAR3

HEADER_CHAR4

HEADER_CHAR5

HEADER_CHAR6

HEADER_CHAR7

HEADER_CHAR8

HEADER_CHAR9

HEADER_CHAR10

HEADER_CHAR11

HEADER_CHAR12

HEADER_CHAR13

HEADER_CHAR14

HEADER_CHAR15

HEADER_CHAR16

HEADER_CHAR17

HEADER_CHAR18

HEADER_CHAR19

HEADER_CHAR20

HEADER_CHAR21

HEADER_CHAR22

HEADER_CHAR23

HEADER_CHAR24

HEADER_CHAR25

HEADER_CHAR26

HEADER_CHAR27

HEADER_CHAR28

HEADER_CHAR29

HEADER_CHAR30

HEADER_NUMERIC1

HEADER_NUMERIC2

HEADER_NUMERIC3

HEADER_NUMERIC4

HEADER_NUMERIC5

HEADER_NUMERIC6

HEADER_NUMERIC7

HEADER_NUMERIC8

HEADER_NUMERIC9

HEADER_NUMERIC10

HEADER_DATE1

HEADER_DATE2

HEADER_DATE3

HEADER_DATE4

HEADER_DATE5

Query

SQL_Statement

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