MSC_ORCH_LINES_V

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name

SALES_ORDER_NUMBER SOURCE_ORDER_SYSTEM SALES_ORDER_HEADER_ID ORCH_ORDER_HEADER_ID ORDERED_DATE ORCH_ORDER_NUMBER ORDER_TYPE_CODE ORCH_ORDER_OPEN_FLAG ORCH_ORDER_STATUS_CODE ORCH_ORDER_CANCELED_FLAG CUSTOMER_ACCOUNT_ID SALES_ORDER_LINE_ID SALES_ORDER_LINE_NUMBER ORCH_ORDER_LINE_ID ORCH_LINE_NUMBER INVENTORY_ITEM_ID ORDERED_QTY SHIPPED_QTY ORCH_LINE_STATUS_CODE ORCH_LINE_CANCELED_QTY ORG_ID ORDERED_UOM SOURCE_ORG_ID ACTUAL_SHIP_DATE SCHEDULE_SHIP_DATE FULFILLED_QTY FULFILLMENT_DATE ORCH_LINE_OPEN_FLAG ITEM_TYPE_CODE ORCH_LINE_CANCELED_FLAG

Query

SQL_Statement

select hd.Source_Order_Number sales_order_number, hd.Source_order_System, hd.Source_Order_ID sales_order_header_id, hd.header_id orch_order_header_id, hd.ordered_date, hd.order_number orch_order_number, hd.order_type_code, hd.open_flag orch_order_open_flag, hd.status_code orch_order_status_code, hd.canceled_flag orch_order_canceled_flag, hd.sold_to_customer_id customer_account_id, ll.Source_Line_Id sales_order_line_id, ll.Source_Line_Number sales_order_line_number, ll.line_id orch_order_line_id, ll.line_number orch_line_number, ll.inventory_item_id, ll.ordered_qty, ll.shipped_qty, ll.status_code orch_line_status_code, ll.canceled_qty orch_line_canceled_qty, ll.org_id, ll.ordered_uom, ll.source_org_id, ll.actual_ship_date, ll.schedule_ship_date, ll.fulfilled_qty, ll.fulfillment_date, ll.open_flag orch_line_open_flag, ll.item_type_code, ll.canceled_flag orch_line_canceled_flag from doo_headers_all hd, doo_lines_all ll where hd.header_id = ll.header_id