1. Tables and Views for SCM
  2. CST_XLA_TRANSFER_ORDER_HDRS_V

CST_XLA_TRANSFER_ORDER_HDRS_V

Details

  • Schema: FUSION

  • Object owner: CST

  • Object type: VIEW

Columns

Name

TO_LINE_ID

TO_HEADER_ID

TO_HEADER_NUMBER

TO_HEADER_ATTRIBUTE_CATEGORY

TO_HEADER_ATTRIBUTE_CHAR1

TO_HEADER_ATTRIBUTE_CHAR2

TO_HEADER_ATTRIBUTE_CHAR3

TO_HEADER_ATTRIBUTE_CHAR4

TO_HEADER_ATTRIBUTE_CHAR5

TO_HEADER_ATTRIBUTE_CHAR6

TO_HEADER_ATTRIBUTE_CHAR7

TO_HEADER_ATTRIBUTE_CHAR8

TO_HEADER_ATTRIBUTE_CHAR9

TO_HEADER_ATTRIBUTE_CHAR10

TO_HEADER_ATTRIBUTE_CHAR11

TO_HEADER_ATTRIBUTE_CHAR12

TO_HEADER_ATTRIBUTE_CHAR13

TO_HEADER_ATTRIBUTE_CHAR14

TO_HEADER_ATTRIBUTE_CHAR15

TO_HEADER_ATTRIBUTE_CHAR16

TO_HEADER_ATTRIBUTE_CHAR17

TO_HEADER_ATTRIBUTE_CHAR18

TO_HEADER_ATTRIBUTE_CHAR19

TO_HEADER_ATTRIBUTE_CHAR20

TO_HEADER_ATTRIBUTE_NUMBER1

TO_HEADER_ATTRIBUTE_NUMBER2

TO_HEADER_ATTRIBUTE_NUMBER3

TO_HEADER_ATTRIBUTE_NUMBER4

TO_HEADER_ATTRIBUTE_NUMBER5

TO_HEADER_ATTRIBUTE_NUMBER6

TO_HEADER_ATTRIBUTE_NUMBER7

TO_HEADER_ATTRIBUTE_NUMBER8

TO_HEADER_ATTRIBUTE_NUMBER9

TO_HEADER_ATTRIBUTE_NUMBER10

TO_HEADER_ATTRIBUTE_DATE1

TO_HEADER_ATTRIBUTE_DATE2

TO_HEADER_ATTRIBUTE_DATE3

TO_HEADER_ATTRIBUTE_DATE4

TO_HEADER_ATTRIBUTE_DATE5

TO_HEADER_ATTRIBUTE_TIMESTAMP1

TO_HEADER_ATTRIBUTE_TIMESTAMP2

TO_HEADER_ATTRIBUTE_TIMESTAMP3

TO_HEADER_ATTRIBUTE_TIMESTAMP4

TO_HEADER_ATTRIBUTE_TIMESTAMP5

Query

SQL_Statement

SELECT

itol.line_id to_line_id,

itoh.header_id to_header_id,

itoh.header_number to_header_number,

itoh.attribute_category to_header_attribute_category,

itoh.attribute_char1 to_header_attribute_char1,

itoh.attribute_char2 to_header_attribute_char2,

itoh.attribute_char3 to_header_attribute_char3,

itoh.attribute_char4 to_header_attribute_char4,

itoh.attribute_char5 to_header_attribute_char5,

itoh.attribute_char6 to_header_attribute_char6,

itoh.attribute_char7 to_header_attribute_char7,

itoh.attribute_char8 to_header_attribute_char8,

itoh.attribute_char9 to_header_attribute_char9,

itoh.attribute_char10 to_header_attribute_char10,

itoh.attribute_char11 to_header_attribute_char11,

itoh.attribute_char12 to_header_attribute_char12,

itoh.attribute_char13 to_header_attribute_char13,

itoh.attribute_char14 to_header_attribute_char14,

itoh.attribute_char15 to_header_attribute_char15,

itoh.attribute_char16 to_header_attribute_char16,

itoh.attribute_char17 to_header_attribute_char17,

itoh.attribute_char18 to_header_attribute_char18,

itoh.attribute_char19 to_header_attribute_char19,

itoh.attribute_char20 to_header_attribute_char20,

itoh.attribute_number1 to_header_attribute_number1,

itoh.attribute_number2 to_header_attribute_number2,

itoh.attribute_number3 to_header_attribute_number3,

itoh.attribute_number4 to_header_attribute_number4,

itoh.attribute_number5 to_header_attribute_number5,

itoh.attribute_number6 to_header_attribute_number6,

itoh.attribute_number7 to_header_attribute_number7,

itoh.attribute_number8 to_header_attribute_number8,

itoh.attribute_number9 to_header_attribute_number9,

itoh.attribute_number10 to_header_attribute_number10,

itoh.attribute_date1 to_header_attribute_date1,

itoh.attribute_date2 to_header_attribute_date2,

itoh.attribute_date3 to_header_attribute_date3,

itoh.attribute_date4 to_header_attribute_date4,

itoh.attribute_date5 to_header_attribute_date5,

itoh.attribute_timestamp1 to_header_attribute_timestamp1,

itoh.attribute_timestamp2 to_header_attribute_timestamp2,

itoh.attribute_timestamp3 to_header_attribute_timestamp3,

itoh.attribute_timestamp4 to_header_attribute_timestamp4,

itoh.attribute_timestamp5 to_header_attribute_timestamp5

FROM

inv_transfer_order_lines itol,

inv_transfer_order_headers itoh

WHERE

itoh.header_id = itol.header_id