VIEW: CSM.CSM_ORDER_LINES_INQ#

Source

View Text - Preformatted

select LINE_ID LINE_ID, HEADER_ID HEADER_ID, LINE_NUMBER LINE_NUMBER, ORG_ID ORG_ID, TASK_ID TASK_ID, SHIPPING_METHOD_CODE SHIPPING_METHOD_CODE, SCHEDULED_ARRIVAL_DATE SCHEDULED_ARRIVAL_DATE, ORDER_SOURCE_ID ORDER_SOURCE_ID, FULFILLMENT_DATE FULFILLMENT_DATE, ACTUAL_SHIPMENT_DATE ACTUAL_SHIPMENT_DATE, RECEIVED_QTY RECEIVED_QTY, FLOW_STATUS_CODE FLOW_STATUS_CODE, ORDER_STATUS ORDER_STATUS, ORDERED_QUANTITY ORDERED_QUANTITY, SHIPPED_QUANTITY SHIPPED_QUANTITY, SOURCE_ORG_ID SOURCE_ORG_ID, SOURCE_SUBINV SOURCE_SUBINV, CANCELLED_QUANTITY CANCELLED_QUANTITY, SHIPMENT_NUM SHIPMENT_NUM, SHIP_METHOD_MEANING SHIP_METHOD_MEANING, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, CLID$$CS CLID$$CS, DMLTYPE$$ DMLTYPE$$, SEQNO$$ SEQNO$$, TRANID$$ TRANID$$, VERSION$$ VERSION$$ from "CSM"."CSM_ORDER_LINES_INQ"

View Text - HTML Formatted

SELECT LINE_ID LINE_ID
, HEADER_ID HEADER_ID
, LINE_NUMBER LINE_NUMBER
, ORG_ID ORG_ID
, TASK_ID TASK_ID
, SHIPPING_METHOD_CODE SHIPPING_METHOD_CODE
, SCHEDULED_ARRIVAL_DATE SCHEDULED_ARRIVAL_DATE
, ORDER_SOURCE_ID ORDER_SOURCE_ID
, FULFILLMENT_DATE FULFILLMENT_DATE
, ACTUAL_SHIPMENT_DATE ACTUAL_SHIPMENT_DATE
, RECEIVED_QTY RECEIVED_QTY
, FLOW_STATUS_CODE FLOW_STATUS_CODE
, ORDER_STATUS ORDER_STATUS
, ORDERED_QUANTITY ORDERED_QUANTITY
, SHIPPED_QUANTITY SHIPPED_QUANTITY
, SOURCE_ORG_ID SOURCE_ORG_ID
, SOURCE_SUBINV SOURCE_SUBINV
, CANCELLED_QUANTITY CANCELLED_QUANTITY
, SHIPMENT_NUM SHIPMENT_NUM
, SHIP_METHOD_MEANING SHIP_METHOD_MEANING
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, CLID$$CS CLID$$CS
, DMLTYPE$$ DMLTYPE$$
, SEQNO$$ SEQNO$$
, TRANID$$ TRANID$$
, VERSION$$ VERSION$$
FROM "CSM"."CSM_ORDER_LINES_INQ"