1. Tables and Views for SCM
  2. CST_XLA_INV_REQUEST_HDRS_V

CST_XLA_INV_REQUEST_HDRS_V

Details

  • Schema: FUSION

  • Object owner: CST

  • Object type: VIEW

Columns

Name

EXTERNAL_SYSTEM_REF_ID

MR_ATTRIBUTE_CATEGORY

MR_ATTRIBUTE1

MR_ATTRIBUTE2

MR_ATTRIBUTE3

MR_ATTRIBUTE4

MR_ATTRIBUTE5

MR_ATTRIBUTE6

MR_ATTRIBUTE7

MR_ATTRIBUTE8

MR_ATTRIBUTE9

MR_ATTRIBUTE10

MR_ATTRIBUTE11

MR_ATTRIBUTE12

MR_ATTRIBUTE13

MR_ATTRIBUTE14

MR_ATTRIBUTE15

MR_ATTRIBUTE16

MR_ATTRIBUTE17

MR_ATTRIBUTE18

MR_ATTRIBUTE19

MR_ATTRIBUTE20

MR_ATTRIBUTE_NUMBER1

MR_ATTRIBUTE_NUMBER2

MR_ATTRIBUTE_NUMBER3

MR_ATTRIBUTE_NUMBER4

MR_ATTRIBUTE_NUMBER5

MR_ATTRIBUTE_NUMBER6

MR_ATTRIBUTE_NUMBER7

MR_ATTRIBUTE_NUMBER8

MR_ATTRIBUTE_NUMBER9

MR_ATTRIBUTE_NUMBER10

MR_ATTRIBUTE_DATE1

MR_ATTRIBUTE_DATE2

MR_ATTRIBUTE_DATE3

MR_ATTRIBUTE_DATE4

MR_ATTRIBUTE_DATE5

MR_ATTRIBUTE_TIMESTAMP1

MR_ATTRIBUTE_TIMESTAMP2

MR_ATTRIBUTE_TIMESTAMP3

MR_ATTRIBUTE_TIMESTAMP4

MR_ATTRIBUTE_TIMESTAMP5

Query

SQL_Statement

SELECT imt.transaction_id external_system_ref_id,

itrh.attribute_category mr_attribute_category,

itrh.attribute1 mr_attribute1,

itrh.attribute2 mr_attribute2,

itrh.attribute3 mr_attribute3,

itrh.attribute4 mr_attribute4,

itrh.attribute5 mr_attribute5,

itrh.attribute6 mr_attribute6,

itrh.attribute7 mr_attribute7,

itrh.attribute8 mr_attribute8,

itrh.attribute9 mr_attribute9,

itrh.attribute10 mr_attribute10,

itrh.attribute11 mr_attribute11,

itrh.attribute12 mr_attribute12,

itrh.attribute13 mr_attribute13,

itrh.attribute14 mr_attribute14,

itrh.attribute15 mr_attribute15,

itrh.attribute16 mr_attribute16,

itrh.attribute17 mr_attribute17,

itrh.attribute18 mr_attribute18,

itrh.attribute19 mr_attribute19,

itrh.attribute20 mr_attribute20,

itrh.attribute_number1 mr_attribute_number1,

itrh.attribute_number2 mr_attribute_number2,

itrh.attribute_number3 mr_attribute_number3,

itrh.attribute_number4 mr_attribute_number4,

itrh.attribute_number5 mr_attribute_number5,

itrh.attribute_number6 mr_attribute_number6,

itrh.attribute_number7 mr_attribute_number7,

itrh.attribute_number8 mr_attribute_number8,

itrh.attribute_number9 mr_attribute_number9,

itrh.attribute_number10 mr_attribute_number10,

itrh.attribute_date1 mr_attribute_date1,

itrh.attribute_date2 mr_attribute_date2,

itrh.attribute_date3 mr_attribute_date3,

itrh.attribute_date4 mr_attribute_date4,

itrh.attribute_date5 mr_attribute_date5,

itrh.attribute_timestamp1 mr_attribute_timestamp1,

itrh.attribute_timestamp2 mr_attribute_timestamp2,

itrh.attribute_timestamp3 mr_attribute_timestamp3,

itrh.attribute_timestamp4 mr_attribute_timestamp4,

itrh.attribute_timestamp5 mr_attribute_timestamp5

FROM inv_txn_request_headers itrh,

inv_material_txns imt

WHERE imt.transaction_source_id = itrh.header_id

AND imt.transaction_source_type_id = 4

AND imt.transaction_action_id IN (1, 2)