[Home] [Help] [Dependency Information]
Object Name: | CSM_ORDER_LINES_INQ# |
---|---|
Object Type: | VIEW |
Owner: | CSM |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LINE_ID | NUMBER | Yes | ||
HEADER_ID | NUMBER | Yes | ||
LINE_NUMBER | NUMBER | Yes | ||
ORG_ID | NUMBER | |||
TASK_ID | NUMBER | |||
SHIPPING_METHOD_CODE | VARCHAR2 | (30) | ||
SCHEDULED_ARRIVAL_DATE | DATE | |||
ORDER_SOURCE_ID | NUMBER | |||
FULFILLMENT_DATE | DATE | |||
ACTUAL_SHIPMENT_DATE | DATE | |||
RECEIVED_QTY | NUMBER | |||
FLOW_STATUS_CODE | VARCHAR2 | (30) | ||
ORDER_STATUS | VARCHAR2 | (4000) | ||
ORDERED_QUANTITY | NUMBER | |||
SHIPPED_QUANTITY | NUMBER | |||
SOURCE_ORG_ID | NUMBER | |||
SOURCE_SUBINV | VARCHAR2 | (10) | ||
CANCELLED_QUANTITY | NUMBER | |||
SHIPMENT_NUM | VARCHAR2 | (30) | ||
SHIP_METHOD_MEANING | VARCHAR2 | (240) | ||
INVENTORY_ITEM_ID | NUMBER | |||
CLID$$CS | VARCHAR2 | (100) | Yes | |
DMLTYPE$$ | VARCHAR2 | (1) | Yes | |
SEQNO$$ | NUMBER | Yes | ||
TRANID$$ | NUMBER | Yes | ||
VERSION$$ | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT LINE_ID
, HEADER_ID
, LINE_NUMBER
, ORG_ID
, TASK_ID
, SHIPPING_METHOD_CODE
, SCHEDULED_ARRIVAL_DATE
, ORDER_SOURCE_ID
, FULFILLMENT_DATE
, ACTUAL_SHIPMENT_DATE
, RECEIVED_QTY
, FLOW_STATUS_CODE
, ORDER_STATUS
, ORDERED_QUANTITY
, SHIPPED_QUANTITY
, SOURCE_ORG_ID
, SOURCE_SUBINV
, CANCELLED_QUANTITY
, SHIPMENT_NUM
, SHIP_METHOD_MEANING
, INVENTORY_ITEM_ID
, CLID$$CS
, DMLTYPE$$
, SEQNO$$
, TRANID$$
, VERSION$$
FROM CSM.CSM_ORDER_LINES_INQ#;
|
|
|