CST_XLA_WSH_DELIVERY_DETAILS

Details

Schema: FUSION
Object owner: CST
Object type: VIEW

Columns

Name
CST_INV_TRANSACTION_ID WSH_DELIVERY_DETAIL_ID SHIP_LINE_STD_ATTR_CATEGORY SHIP_LINE_STD_ATTR1 SHIP_LINE_STD_ATTR2 SHIP_LINE_STD_ATTR3 SHIP_LINE_STD_ATTR4 SHIP_LINE_STD_ATTR5 SHIP_LINE_STD_ATTR6 SHIP_LINE_STD_ATTR7 SHIP_LINE_STD_ATTR8 SHIP_LINE_STD_ATTR9 SHIP_LINE_STD_ATTR10 SHIP_LINE_STD_ATTR11 SHIP_LINE_STD_ATTR12 SHIP_LINE_STD_ATTR13 SHIP_LINE_STD_ATTR14 SHIP_LINE_STD_ATTR15 SHIP_LINE_STD_ATTR16 SHIP_LINE_STD_ATTR17 SHIP_LINE_STD_ATTR18 SHIP_LINE_STD_ATTR19 SHIP_LINE_STD_ATTR20 SHIP_LINE_STD_ATTR_NUMBER1 SHIP_LINE_STD_ATTR_NUMBER2 SHIP_LINE_STD_ATTR_NUMBER3 SHIP_LINE_STD_ATTR_NUMBER4 SHIP_LINE_STD_ATTR_NUMBER5 SHIP_LINE_STD_ATTR_NUMBER6 SHIP_LINE_STD_ATTR_NUMBER7 SHIP_LINE_STD_ATTR_NUMBER8 SHIP_LINE_STD_ATTR_NUMBER9 SHIP_LINE_STD_ATTR_NUMBER10 SHIP_LINE_STD_ATTR_DATE1 SHIP_LINE_STD_ATTR_DATE2 SHIP_LINE_STD_ATTR_DATE3 SHIP_LINE_STD_ATTR_DATE4 SHIP_LINE_STD_ATTR_DATE5 SHIP_LINE_STD_ATTR_TIMESTAMP1 SHIP_LINE_STD_ATTR_TIMESTAMP2 SHIP_LINE_STD_ATTR_TIMESTAMP3 SHIP_LINE_STD_ATTR_TIMESTAMP4 SHIP_LINE_STD_ATTR_TIMESTAMP5 SHIP_LINE_SRC_ATTR_CATEGORY SHIP_LINE_SRC_ATTR1 SHIP_LINE_SRC_ATTR2 SHIP_LINE_SRC_ATTR3 SHIP_LINE_SRC_ATTR4 SHIP_LINE_SRC_ATTR5 SHIP_LINE_SRC_ATTR6 SHIP_LINE_SRC_ATTR7 SHIP_LINE_SRC_ATTR8 SHIP_LINE_SRC_ATTR9 SHIP_LINE_SRC_ATTR10 SHIP_LINE_SRC_ATTR11 SHIP_LINE_SRC_ATTR12 SHIP_LINE_SRC_ATTR13 SHIP_LINE_SRC_ATTR14 SHIP_LINE_SRC_ATTR15 SHIP_LINE_SRC_ATTR16 SHIP_LINE_SRC_ATTR17 SHIP_LINE_SRC_ATTR18 SHIP_LINE_SRC_ATTR19 SHIP_LINE_SRC_ATTR20 SHIP_LINE_SRC_ATTR_NUMBER1 SHIP_LINE_SRC_ATTR_NUMBER2 SHIP_LINE_SRC_ATTR_NUMBER3 SHIP_LINE_SRC_ATTR_NUMBER4 SHIP_LINE_SRC_ATTR_NUMBER5 SHIP_LINE_SRC_ATTR_NUMBER6 SHIP_LINE_SRC_ATTR_NUMBER7 SHIP_LINE_SRC_ATTR_NUMBER8 SHIP_LINE_SRC_ATTR_NUMBER9 SHIP_LINE_SRC_ATTR_NUMBER10 SHIP_LINE_SRC_ATTR_DATE1 SHIP_LINE_SRC_ATTR_DATE2 SHIP_LINE_SRC_ATTR_DATE3 SHIP_LINE_SRC_ATTR_DATE4 SHIP_LINE_SRC_ATTR_DATE5 SHIP_LINE_SRC_ATTR_TIMESTAMP1 SHIP_LINE_SRC_ATTR_TIMESTAMP2 SHIP_LINE_SRC_ATTR_TIMESTAMP3 SHIP_LINE_SRC_ATTR_TIMESTAMP4 SHIP_LINE_SRC_ATTR_TIMESTAMP5

Name

CST_INV_TRANSACTION_ID

WSH_DELIVERY_DETAIL_ID

SHIP_LINE_STD_ATTR_CATEGORY

SHIP_LINE_STD_ATTR1

SHIP_LINE_STD_ATTR2

SHIP_LINE_STD_ATTR3

SHIP_LINE_STD_ATTR4

SHIP_LINE_STD_ATTR5

SHIP_LINE_STD_ATTR6

SHIP_LINE_STD_ATTR7

SHIP_LINE_STD_ATTR8

SHIP_LINE_STD_ATTR9

SHIP_LINE_STD_ATTR10

SHIP_LINE_STD_ATTR11

SHIP_LINE_STD_ATTR12

SHIP_LINE_STD_ATTR13

SHIP_LINE_STD_ATTR14

SHIP_LINE_STD_ATTR15

SHIP_LINE_STD_ATTR16

SHIP_LINE_STD_ATTR17

SHIP_LINE_STD_ATTR18

SHIP_LINE_STD_ATTR19

SHIP_LINE_STD_ATTR20

SHIP_LINE_STD_ATTR_NUMBER1

SHIP_LINE_STD_ATTR_NUMBER2

SHIP_LINE_STD_ATTR_NUMBER3

SHIP_LINE_STD_ATTR_NUMBER4

SHIP_LINE_STD_ATTR_NUMBER5

SHIP_LINE_STD_ATTR_NUMBER6

SHIP_LINE_STD_ATTR_NUMBER7

SHIP_LINE_STD_ATTR_NUMBER8

SHIP_LINE_STD_ATTR_NUMBER9

SHIP_LINE_STD_ATTR_NUMBER10

SHIP_LINE_STD_ATTR_DATE1

SHIP_LINE_STD_ATTR_DATE2

SHIP_LINE_STD_ATTR_DATE3

SHIP_LINE_STD_ATTR_DATE4

SHIP_LINE_STD_ATTR_DATE5

SHIP_LINE_STD_ATTR_TIMESTAMP1

SHIP_LINE_STD_ATTR_TIMESTAMP2

SHIP_LINE_STD_ATTR_TIMESTAMP3

SHIP_LINE_STD_ATTR_TIMESTAMP4

SHIP_LINE_STD_ATTR_TIMESTAMP5

SHIP_LINE_SRC_ATTR_CATEGORY

SHIP_LINE_SRC_ATTR1

SHIP_LINE_SRC_ATTR2

SHIP_LINE_SRC_ATTR3

SHIP_LINE_SRC_ATTR4

SHIP_LINE_SRC_ATTR5

SHIP_LINE_SRC_ATTR6

SHIP_LINE_SRC_ATTR7

SHIP_LINE_SRC_ATTR8

SHIP_LINE_SRC_ATTR9

SHIP_LINE_SRC_ATTR10

SHIP_LINE_SRC_ATTR11

SHIP_LINE_SRC_ATTR12

SHIP_LINE_SRC_ATTR13

SHIP_LINE_SRC_ATTR14

SHIP_LINE_SRC_ATTR15

SHIP_LINE_SRC_ATTR16

SHIP_LINE_SRC_ATTR17

SHIP_LINE_SRC_ATTR18

SHIP_LINE_SRC_ATTR19

SHIP_LINE_SRC_ATTR20

SHIP_LINE_SRC_ATTR_NUMBER1

SHIP_LINE_SRC_ATTR_NUMBER2

SHIP_LINE_SRC_ATTR_NUMBER3

SHIP_LINE_SRC_ATTR_NUMBER4

SHIP_LINE_SRC_ATTR_NUMBER5

SHIP_LINE_SRC_ATTR_NUMBER6

SHIP_LINE_SRC_ATTR_NUMBER7

SHIP_LINE_SRC_ATTR_NUMBER8

SHIP_LINE_SRC_ATTR_NUMBER9

SHIP_LINE_SRC_ATTR_NUMBER10

SHIP_LINE_SRC_ATTR_DATE1

SHIP_LINE_SRC_ATTR_DATE2

SHIP_LINE_SRC_ATTR_DATE3

SHIP_LINE_SRC_ATTR_DATE4

SHIP_LINE_SRC_ATTR_DATE5

SHIP_LINE_SRC_ATTR_TIMESTAMP1

SHIP_LINE_SRC_ATTR_TIMESTAMP2

SHIP_LINE_SRC_ATTR_TIMESTAMP3

SHIP_LINE_SRC_ATTR_TIMESTAMP4

SHIP_LINE_SRC_ATTR_TIMESTAMP5

Query

SQL_Statement
SELECT cit.cst_inv_transaction_id cst_inv_transaction_id, wdd.delivery_detail_id wsh_delivery_detail_id, wdd.attribute_category ship_line_std_attr_category, wdd.attribute1 ship_line_std_attr1, wdd.attribute2 ship_line_std_attr2, wdd.attribute3 ship_line_std_attr3, wdd.attribute4 ship_line_std_attr4, wdd.attribute5 ship_line_std_attr5, wdd.attribute6 ship_line_std_attr6, wdd.attribute7 ship_line_std_attr7, wdd.attribute8 ship_line_std_attr8, wdd.attribute9 ship_line_std_attr9, wdd.attribute10 ship_line_std_attr10, wdd.attribute11 ship_line_std_attr11, wdd.attribute12 ship_line_std_attr12, wdd.attribute13 ship_line_std_attr13, wdd.attribute14 ship_line_std_attr14, wdd.attribute15 ship_line_std_attr15, wdd.attribute16 ship_line_std_attr16, wdd.attribute17 ship_line_std_attr17, wdd.attribute18 ship_line_std_attr18, wdd.attribute19 ship_line_std_attr19, wdd.attribute20 ship_line_std_attr20, wdd.attribute_number1 ship_line_std_attr_number1, wdd.attribute_number2 ship_line_std_attr_number2, wdd.attribute_number3 ship_line_std_attr_number3, wdd.attribute_number4 ship_line_std_attr_number4, wdd.attribute_number5 ship_line_std_attr_number5, wdd.attribute_number6 ship_line_std_attr_number6, wdd.attribute_number7 ship_line_std_attr_number7, wdd.attribute_number8 ship_line_std_attr_number8, wdd.attribute_number9 ship_line_std_attr_number9, wdd.attribute_number10 ship_line_std_attr_number10, wdd.attribute_date1 ship_line_std_attr_date1, wdd.attribute_date2 ship_line_std_attr_date2, wdd.attribute_date3 ship_line_std_attr_date3, wdd.attribute_date4 ship_line_std_attr_date4, wdd.attribute_date5 ship_line_std_attr_date5, wdd.attribute_timestamp1 ship_line_std_attr_timestamp1, wdd.attribute_timestamp2 ship_line_std_attr_timestamp2, wdd.attribute_timestamp3 ship_line_std_attr_timestamp3, wdd.attribute_timestamp4 ship_line_std_attr_timestamp4, wdd.attribute_timestamp5 ship_line_std_attr_timestamp5, wdd.src_attribute_category ship_line_src_attr_category, wdd.src_attribute1 ship_line_src_attr1, wdd.src_attribute2 ship_line_src_attr2, wdd.src_attribute3 ship_line_src_attr3, wdd.src_attribute4 ship_line_src_attr4, wdd.src_attribute5 ship_line_src_attr5, wdd.src_attribute6 ship_line_src_attr6, wdd.src_attribute7 ship_line_src_attr7, wdd.src_attribute8 ship_line_src_attr8, wdd.src_attribute9 ship_line_src_attr9, wdd.src_attribute10 ship_line_src_attr10, wdd.src_attribute11 ship_line_src_attr11, wdd.src_attribute12 ship_line_src_attr12, wdd.src_attribute13 ship_line_src_attr13, wdd.src_attribute14 ship_line_src_attr14, wdd.src_attribute15 ship_line_src_attr15, wdd.src_attribute16 ship_line_src_attr16, wdd.src_attribute17 ship_line_src_attr17, wdd.src_attribute18 ship_line_src_attr18, wdd.src_attribute19 ship_line_src_attr19, wdd.src_attribute20 ship_line_src_attr20, wdd.src_attribute_number1 ship_line_src_attr_number1, wdd.src_attribute_number2 ship_line_src_attr_number2, wdd.src_attribute_number3 ship_line_src_attr_number3, wdd.src_attribute_number4 ship_line_src_attr_number4, wdd.src_attribute_number5 ship_line_src_attr_number5, wdd.src_attribute_number6 ship_line_src_attr_number6, wdd.src_attribute_number7 ship_line_src_attr_number7, wdd.src_attribute_number8 ship_line_src_attr_number8, wdd.src_attribute_number9 ship_line_src_attr_number9, wdd.src_attribute_number10 ship_line_src_attr_number10, wdd.src_attribute_date1 ship_line_src_attr_date1, wdd.src_attribute_date2 ship_line_src_attr_date2, wdd.src_attribute_date3 ship_line_src_attr_date3, wdd.src_attribute_date4 ship_line_src_attr_date4, wdd.src_attribute_date5 ship_line_src_attr_date5, wdd.src_attribute_timestamp1 ship_line_src_attr_timestamp1, wdd.src_attribute_timestamp2 ship_line_src_attr_timestamp2, wdd.src_attribute_timestamp3 ship_line_src_attr_timestamp3, wdd.src_attribute_timestamp4 ship_line_src_attr_timestamp4, wdd.src_attribute_timestamp5 ship_line_src_attr_timestamp5 FROM cst_inv_transactions cit, inv_material_txns imt, wsh_delivery_details wdd WHERE cit.external_system_reference = 'FUSION' AND cit.external_system_ref_id = imt.transaction_id AND wdd.delivery_detail_id = imt.picking_line_id AND cit.base_txn_source_type_id = 2 AND cit.base_txn_action_id = 1 UNION ALL SELECT cit.cst_inv_transaction_id cst_inv_transaction_id, wdd.delivery_detail_id wsh_delivery_detail_id, wdd.attribute_category ship_line_std_attr_category, wdd.attribute1 ship_line_std_attr1, wdd.attribute2 ship_line_std_attr2, wdd.attribute3 ship_line_std_attr3, wdd.attribute4 ship_line_std_attr4, wdd.attribute5 ship_line_std_attr5, wdd.attribute6 ship_line_std_attr6, wdd.attribute7 ship_line_std_attr7, wdd.attribute8 ship_line_std_attr8, wdd.attribute9 ship_line_std_attr9, wdd.attribute10 ship_line_std_attr10, wdd.attribute11 ship_line_std_attr11, wdd.attribute12 ship_line_std_attr12, wdd.attribute13 ship_line_std_attr13, wdd.attribute14 ship_line_std_attr14, wdd.attribute15 ship_line_std_attr15, wdd.attribute16 ship_line_std_attr16, wdd.attribute17 ship_line_std_attr17, wdd.attribute18 ship_line_std_attr18, wdd.attribute19 ship_line_std_attr19, wdd.attribute20 ship_line_std_attr20, wdd.attribute_number1 ship_line_std_attr_number1, wdd.attribute_number2 ship_line_std_attr_number2, wdd.attribute_number3 ship_line_std_attr_number3, wdd.attribute_number4 ship_line_std_attr_number4, wdd.attribute_number5 ship_line_std_attr_number5, wdd.attribute_number6 ship_line_std_attr_number6, wdd.attribute_number7 ship_line_std_attr_number7, wdd.attribute_number8 ship_line_std_attr_number8, wdd.attribute_number9 ship_line_std_attr_number9, wdd.attribute_number10 ship_line_std_attr_number10, wdd.attribute_date1 ship_line_std_attr_date1, wdd.attribute_date2 ship_line_std_attr_date2, wdd.attribute_date3 ship_line_std_attr_date3, wdd.attribute_date4 ship_line_std_attr_date4, wdd.attribute_date5 ship_line_std_attr_date5, wdd.attribute_timestamp1 ship_line_std_attr_timestamp1, wdd.attribute_timestamp2 ship_line_std_attr_timestamp2, wdd.attribute_timestamp3 ship_line_std_attr_timestamp3, wdd.attribute_timestamp4 ship_line_std_attr_timestamp4, wdd.attribute_timestamp5 ship_line_std_attr_timestamp5, wdd.src_attribute_category ship_line_src_attr_category, wdd.src_attribute1 ship_line_src_attr1, wdd.src_attribute2 ship_line_src_attr2, wdd.src_attribute3 ship_line_src_attr3, wdd.src_attribute4 ship_line_src_attr4, wdd.src_attribute5 ship_line_src_attr5, wdd.src_attribute6 ship_line_src_attr6, wdd.src_attribute7 ship_line_src_attr7, wdd.src_attribute8 ship_line_src_attr8, wdd.src_attribute9 ship_line_src_attr9, wdd.src_attribute10 ship_line_src_attr10, wdd.src_attribute11 ship_line_src_attr11, wdd.src_attribute12 ship_line_src_attr12, wdd.src_attribute13 ship_line_src_attr13, wdd.src_attribute14 ship_line_src_attr14, wdd.src_attribute15 ship_line_src_attr15, wdd.src_attribute16 ship_line_src_attr16, wdd.src_attribute17 ship_line_src_attr17, wdd.src_attribute18 ship_line_src_attr18, wdd.src_attribute19 ship_line_src_attr19, wdd.src_attribute20 ship_line_src_attr20, wdd.src_attribute_number1 ship_line_src_attr_number1, wdd.src_attribute_number2 ship_line_src_attr_number2, wdd.src_attribute_number3 ship_line_src_attr_number3, wdd.src_attribute_number4 ship_line_src_attr_number4, wdd.src_attribute_number5 ship_line_src_attr_number5, wdd.src_attribute_number6 ship_line_src_attr_number6, wdd.src_attribute_number7 ship_line_src_attr_number7, wdd.src_attribute_number8 ship_line_src_attr_number8, wdd.src_attribute_number9 ship_line_src_attr_number9, wdd.src_attribute_number10 ship_line_src_attr_number10, wdd.src_attribute_date1 ship_line_src_attr_date1, wdd.src_attribute_date2 ship_line_src_attr_date2, wdd.src_attribute_date3 ship_line_src_attr_date3, wdd.src_attribute_date4 ship_line_src_attr_date4, wdd.src_attribute_date5 ship_line_src_attr_date5, wdd.src_attribute_timestamp1 ship_line_src_attr_timestamp1, wdd.src_attribute_timestamp2 ship_line_src_attr_timestamp2, wdd.src_attribute_timestamp3 ship_line_src_attr_timestamp3, wdd.src_attribute_timestamp4 ship_line_src_attr_timestamp4, wdd.src_attribute_timestamp5 ship_line_src_attr_timestamp5 FROM cst_inv_transactions cit, cst_trade_events cte, wsh_delivery_details wdd WHERE cit.external_system_reference = 'FOS_INTERNAL' AND cit.external_system_ref_id = cte.trade_event_id AND cte.delivery_detail_id = wdd.delivery_detail_id

SQL_Statement

SELECT

cit.cst_inv_transaction_id cst_inv_transaction_id,

wdd.delivery_detail_id wsh_delivery_detail_id,

wdd.attribute_category ship_line_std_attr_category,

wdd.attribute1 ship_line_std_attr1,

wdd.attribute2 ship_line_std_attr2,

wdd.attribute3 ship_line_std_attr3,

wdd.attribute4 ship_line_std_attr4,

wdd.attribute5 ship_line_std_attr5,

wdd.attribute6 ship_line_std_attr6,

wdd.attribute7 ship_line_std_attr7,

wdd.attribute8 ship_line_std_attr8,

wdd.attribute9 ship_line_std_attr9,

wdd.attribute10 ship_line_std_attr10,

wdd.attribute11 ship_line_std_attr11,

wdd.attribute12 ship_line_std_attr12,

wdd.attribute13 ship_line_std_attr13,

wdd.attribute14 ship_line_std_attr14,

wdd.attribute15 ship_line_std_attr15,

wdd.attribute16 ship_line_std_attr16,

wdd.attribute17 ship_line_std_attr17,

wdd.attribute18 ship_line_std_attr18,

wdd.attribute19 ship_line_std_attr19,

wdd.attribute20 ship_line_std_attr20,

wdd.attribute_number1 ship_line_std_attr_number1,

wdd.attribute_number2 ship_line_std_attr_number2,

wdd.attribute_number3 ship_line_std_attr_number3,

wdd.attribute_number4 ship_line_std_attr_number4,

wdd.attribute_number5 ship_line_std_attr_number5,

wdd.attribute_number6 ship_line_std_attr_number6,

wdd.attribute_number7 ship_line_std_attr_number7,

wdd.attribute_number8 ship_line_std_attr_number8,

wdd.attribute_number9 ship_line_std_attr_number9,

wdd.attribute_number10 ship_line_std_attr_number10,

wdd.attribute_date1 ship_line_std_attr_date1,

wdd.attribute_date2 ship_line_std_attr_date2,

wdd.attribute_date3 ship_line_std_attr_date3,

wdd.attribute_date4 ship_line_std_attr_date4,

wdd.attribute_date5 ship_line_std_attr_date5,

wdd.attribute_timestamp1 ship_line_std_attr_timestamp1,

wdd.attribute_timestamp2 ship_line_std_attr_timestamp2,

wdd.attribute_timestamp3 ship_line_std_attr_timestamp3,

wdd.attribute_timestamp4 ship_line_std_attr_timestamp4,

wdd.attribute_timestamp5 ship_line_std_attr_timestamp5,

wdd.src_attribute_category ship_line_src_attr_category,

wdd.src_attribute1 ship_line_src_attr1,

wdd.src_attribute2 ship_line_src_attr2,

wdd.src_attribute3 ship_line_src_attr3,

wdd.src_attribute4 ship_line_src_attr4,

wdd.src_attribute5 ship_line_src_attr5,

wdd.src_attribute6 ship_line_src_attr6,

wdd.src_attribute7 ship_line_src_attr7,

wdd.src_attribute8 ship_line_src_attr8,

wdd.src_attribute9 ship_line_src_attr9,

wdd.src_attribute10 ship_line_src_attr10,

wdd.src_attribute11 ship_line_src_attr11,

wdd.src_attribute12 ship_line_src_attr12,

wdd.src_attribute13 ship_line_src_attr13,

wdd.src_attribute14 ship_line_src_attr14,

wdd.src_attribute15 ship_line_src_attr15,

wdd.src_attribute16 ship_line_src_attr16,

wdd.src_attribute17 ship_line_src_attr17,

wdd.src_attribute18 ship_line_src_attr18,

wdd.src_attribute19 ship_line_src_attr19,

wdd.src_attribute20 ship_line_src_attr20,

wdd.src_attribute_number1 ship_line_src_attr_number1,

wdd.src_attribute_number2 ship_line_src_attr_number2,

wdd.src_attribute_number3 ship_line_src_attr_number3,

wdd.src_attribute_number4 ship_line_src_attr_number4,

wdd.src_attribute_number5 ship_line_src_attr_number5,

wdd.src_attribute_number6 ship_line_src_attr_number6,

wdd.src_attribute_number7 ship_line_src_attr_number7,

wdd.src_attribute_number8 ship_line_src_attr_number8,

wdd.src_attribute_number9 ship_line_src_attr_number9,

wdd.src_attribute_number10 ship_line_src_attr_number10,

wdd.src_attribute_date1 ship_line_src_attr_date1,

wdd.src_attribute_date2 ship_line_src_attr_date2,

wdd.src_attribute_date3 ship_line_src_attr_date3,

wdd.src_attribute_date4 ship_line_src_attr_date4,

wdd.src_attribute_date5 ship_line_src_attr_date5,

wdd.src_attribute_timestamp1 ship_line_src_attr_timestamp1,

wdd.src_attribute_timestamp2 ship_line_src_attr_timestamp2,

wdd.src_attribute_timestamp3 ship_line_src_attr_timestamp3,

wdd.src_attribute_timestamp4 ship_line_src_attr_timestamp4,

wdd.src_attribute_timestamp5 ship_line_src_attr_timestamp5

FROM

cst_inv_transactions cit,

inv_material_txns imt,

wsh_delivery_details wdd

WHERE

cit.external_system_reference = 'FUSION'

AND cit.external_system_ref_id = imt.transaction_id

AND wdd.delivery_detail_id = imt.picking_line_id

AND cit.base_txn_source_type_id = 2

AND cit.base_txn_action_id = 1

UNION ALL