1. Tables and Views for SCM
  2. CST_XLA_TRANSFER_ORDER_LINES_V

CST_XLA_TRANSFER_ORDER_LINES_V

Details

  • Schema: FUSION

  • Object owner: CST

  • Object type: VIEW

Columns

Name

TO_LINE_ID

TO_HEADER_ID

TO_LINE_NUMBER

TO_SHIP_TO_LOCATION_ID

TO_LINE_ATTRIBUTE_CATEGORY

TO_LINE_ATTRIBUTE_CHAR1

TO_LINE_ATTRIBUTE_CHAR2

TO_LINE_ATTRIBUTE_CHAR3

TO_LINE_ATTRIBUTE_CHAR4

TO_LINE_ATTRIBUTE_CHAR5

TO_LINE_ATTRIBUTE_CHAR6

TO_LINE_ATTRIBUTE_CHAR7

TO_LINE_ATTRIBUTE_CHAR8

TO_LINE_ATTRIBUTE_CHAR9

TO_LINE_ATTRIBUTE_CHAR10

TO_LINE_ATTRIBUTE_CHAR11

TO_LINE_ATTRIBUTE_CHAR12

TO_LINE_ATTRIBUTE_CHAR13

TO_LINE_ATTRIBUTE_CHAR14

TO_LINE_ATTRIBUTE_CHAR15

TO_LINE_ATTRIBUTE_CHAR16

TO_LINE_ATTRIBUTE_CHAR17

TO_LINE_ATTRIBUTE_CHAR18

TO_LINE_ATTRIBUTE_CHAR19

TO_LINE_ATTRIBUTE_CHAR20

TO_LINE_ATTRIBUTE_NUMBER1

TO_LINE_ATTRIBUTE_NUMBER2

TO_LINE_ATTRIBUTE_NUMBER3

TO_LINE_ATTRIBUTE_NUMBER4

TO_LINE_ATTRIBUTE_NUMBER5

TO_LINE_ATTRIBUTE_NUMBER6

TO_LINE_ATTRIBUTE_NUMBER7

TO_LINE_ATTRIBUTE_NUMBER8

TO_LINE_ATTRIBUTE_NUMBER9

TO_LINE_ATTRIBUTE_NUMBER10

TO_LINE_ATTRIBUTE_DATE1

TO_LINE_ATTRIBUTE_DATE2

TO_LINE_ATTRIBUTE_DATE3

TO_LINE_ATTRIBUTE_DATE4

TO_LINE_ATTRIBUTE_DATE5

TO_LINE_ATTRIBUTE_TIMESTAMP1

TO_LINE_ATTRIBUTE_TIMESTAMP2

TO_LINE_ATTRIBUTE_TIMESTAMP3

TO_LINE_ATTRIBUTE_TIMESTAMP4

TO_LINE_ATTRIBUTE_TIMESTAMP5

TO_LINE_DEST_TYPE_LOOKUP

Query

SQL_Statement

SELECT

itol.line_id to_line_id,

itol.header_id to_header_id,

itol.line_number to_line_number,

itol.destination_location_id to_ship_to_location_id,

itol.attribute_category to_line_attribute_category,

itol.attribute_char1 to_line_attribute_char1,

itol.attribute_char2 to_line_attribute_char2,

itol.attribute_char3 to_line_attribute_char3,

itol.attribute_char4 to_line_attribute_char4,

itol.attribute_char5 to_line_attribute_char5,

itol.attribute_char6 to_line_attribute_char6,

itol.attribute_char7 to_line_attribute_char7,

itol.attribute_char8 to_line_attribute_char8,

itol.attribute_char9 to_line_attribute_char9,

itol.attribute_char10 to_line_attribute_char10,

itol.attribute_char11 to_line_attribute_char11,

itol.attribute_char12 to_line_attribute_char12,

itol.attribute_char13 to_line_attribute_char13,

itol.attribute_char14 to_line_attribute_char14,

itol.attribute_char15 to_line_attribute_char15,

itol.attribute_char16 to_line_attribute_char16,

itol.attribute_char17 to_line_attribute_char17,

itol.attribute_char18 to_line_attribute_char18,

itol.attribute_char19 to_line_attribute_char19,

itol.attribute_char20 to_line_attribute_char20,

itol.attribute_number1 to_line_attribute_number1,

itol.attribute_number2 to_line_attribute_number2,

itol.attribute_number3 to_line_attribute_number3,

itol.attribute_number4 to_line_attribute_number4,

itol.attribute_number5 to_line_attribute_number5,

itol.attribute_number6 to_line_attribute_number6,

itol.attribute_number7 to_line_attribute_number7,

itol.attribute_number8 to_line_attribute_number8,

itol.attribute_number9 to_line_attribute_number9,

itol.attribute_number10 to_line_attribute_number10,

itol.attribute_date1 to_line_attribute_date1,

itol.attribute_date2 to_line_attribute_date2,

itol.attribute_date3 to_line_attribute_date3,

itol.attribute_date4 to_line_attribute_date4,

itol.attribute_date5 to_line_attribute_date5,

itol.attribute_timestamp1 to_line_attribute_timestamp1,

itol.attribute_timestamp2 to_line_attribute_timestamp2,

itol.attribute_timestamp3 to_line_attribute_timestamp3,

itol.attribute_timestamp4 to_line_attribute_timestamp4,

itol.attribute_timestamp5 to_line_attribute_timestamp5,

itol.destination_type_lookup to_line_dest_type_lookup

FROM

inv_transfer_order_lines itol