DBA Data[Home] [Help] [Dependency Information]

VIEW: CSM.CSM_ORDER_LINES_INQ#

Object Details
Object Name: CSM_ORDER_LINES_INQ#
Object Type: VIEW
Owner: CSM
Subobject Name:
Status: VALID

[View Source]

Columns
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

Query Text

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#;

Dependencies

[top of page]

CSM.CSM_ORDER_LINES_INQ# references the following:

SchemaCSM
TableCSM_ORDER_LINES_INQ
CSM.CSM_ORDER_LINES_INQ# is referenced by following:

SchemaAPPS
SynonymCSM_ORDER_LINES_INQ