1. Tables and Views for Financials
  2. ZX_SYNC_LINES_INPUT_V

ZX_SYNC_LINES_INPUT_V

Details

  • Schema: FUSION

  • Object owner: FND

  • Object type: VIEW

Columns

Name

DOCUMENT_TYPE_ID

TRANSACTION_ID

TRANSACTION_LINE_ID

TRX_LEVEL_TYPE

TRX_LINE_NUMBER

TRX_LINE_DESCRIPTION

PRODUCT_DESCRIPTION

LINE_CHAR1

LINE_CHAR2

LINE_CHAR3

LINE_CHAR4

LINE_CHAR5

LINE_CHAR6

LINE_CHAR7

LINE_CHAR8

LINE_CHAR9

LINE_CHAR10

LINE_CHAR11

LINE_CHAR12

LINE_CHAR13

LINE_CHAR14

LINE_CHAR15

LINE_CHAR16

LINE_CHAR17

LINE_CHAR18

LINE_CHAR19

LINE_CHAR20

LINE_CHAR21

LINE_CHAR22

LINE_CHAR23

LINE_CHAR24

LINE_CHAR25

LINE_CHAR26

LINE_CHAR27

LINE_CHAR28

LINE_CHAR29

LINE_CHAR30

LINE_NUMERIC1

LINE_NUMERIC2

LINE_NUMERIC3

LINE_NUMERIC4

LINE_NUMERIC5

LINE_NUMERIC6

LINE_NUMERIC7

LINE_NUMERIC8

LINE_NUMERIC9

LINE_NUMERIC10

LINE_DATE1

LINE_DATE2

LINE_DATE3

LINE_DATE4

LINE_DATE5

Query

SQL_Statement

SELECT

/* Removed as per Bug 5090593

zldf.internal_organization_id,

ztppo.legal_entity_number,

ztppo.establishment_name,

*/

zldf.event_class_mapping_id,

zldf.trx_id,

zldf.trx_line_id,

zldf.trx_level_type,

zldf.trx_line_number, /*Bug 5090593 trx_number changed to trx_line_number */

zldf.trx_description,

zldf.product_description,

zpslea.LINE_EXT_VARCHAR_ATTRIBUTE1,

zpslea.LINE_EXT_VARCHAR_ATTRIBUTE2,

zpslea.LINE_EXT_VARCHAR_ATTRIBUTE3,

zpslea.LINE_EXT_VARCHAR_ATTRIBUTE4,

zpslea.LINE_EXT_VARCHAR_ATTRIBUTE5,

zpslea.LINE_EXT_VARCHAR_ATTRIBUTE6,

zpslea.LINE_EXT_VARCHAR_ATTRIBUTE7,

zpslea.LINE_EXT_VARCHAR_ATTRIBUTE8,

zpslea.LINE_EXT_VARCHAR_ATTRIBUTE9,

zpslea.LINE_EXT_VARCHAR_ATTRIBUTE10,

zpslea.LINE_EXT_VARCHAR_ATTRIBUTE11,

zpslea.LINE_EXT_VARCHAR_ATTRIBUTE12,

zpslea.LINE_EXT_VARCHAR_ATTRIBUTE13,

zpslea.LINE_EXT_VARCHAR_ATTRIBUTE14,

zpslea.LINE_EXT_VARCHAR_ATTRIBUTE15,

zpslea.LINE_EXT_VARCHAR_ATTRIBUTE16,

zpslea.LINE_EXT_VARCHAR_ATTRIBUTE17,

zpslea.LINE_EXT_VARCHAR_ATTRIBUTE18,

zpslea.LINE_EXT_VARCHAR_ATTRIBUTE19,

zpslea.LINE_EXT_VARCHAR_ATTRIBUTE20,

zpslea.LINE_EXT_VARCHAR_ATTRIBUTE21,

zpslea.LINE_EXT_VARCHAR_ATTRIBUTE22,

zpslea.LINE_EXT_VARCHAR_ATTRIBUTE23,

zpslea.LINE_EXT_VARCHAR_ATTRIBUTE24,

zpslea.LINE_EXT_VARCHAR_ATTRIBUTE25,

zpslea.LINE_EXT_VARCHAR_ATTRIBUTE26,

zpslea.LINE_EXT_VARCHAR_ATTRIBUTE27,

zpslea.LINE_EXT_VARCHAR_ATTRIBUTE28,

zpslea.LINE_EXT_VARCHAR_ATTRIBUTE29,

zpslea.LINE_EXT_VARCHAR_ATTRIBUTE30,

zpslea.line_ext_number_attribute1,

zpslea.line_ext_number_attribute2,

zpslea.line_ext_number_attribute3,

zpslea.line_ext_number_attribute4,

zpslea.line_ext_number_attribute5,

zpslea.line_ext_number_attribute6,

zpslea.line_ext_number_attribute7,

zpslea.line_ext_number_attribute8,

zpslea.line_ext_number_attribute9,

zpslea.line_ext_number_attribute10,

zpslea.line_ext_date_attribute1,

zpslea.line_ext_date_attribute2,

zpslea.line_ext_date_attribute3,

zpslea.line_ext_date_attribute4,

zpslea.line_ext_date_attribute5

FROM ZX_LINES_DET_FACTORS zldf,

ZX_TRX_PRE_PROC_OPTIONS_GT ztppo,

ZX_PRVDR_LINE_EXTNS_GT zpslea

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 zldf.event_id = nvl(ztppo.event_id,zldf.event_id)

AND ztppo.record_for_partners_flag = 'Y'

AND ztppo.record_flag = 'Y'

AND ztppo.quote_flag = 'N'

AND ztppo.tax_event_type_code = 'UPDATE' /* line level extensible attributes */

AND zpslea.application_id = ztppo.application_id

AND zpslea.entity_code = ztppo.entity_code

AND zpslea.event_class_code = ztppo.event_class_code

AND zpslea.trx_id = ztppo.trx_id

AND zpslea.provider_id = ztppo.tax_provider_id

AND zpslea.tax_regime_code = ztppo.tax_regime_code