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

VIEW: APPS.CSM_ORDER_LINES_V

Object Details
Object Name: CSM_ORDER_LINES_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ACCESS_ID NUMBER
Yes
LINE_ID NUMBER
Yes
HEADER_ID NUMBER
Yes
LINE_NUMBER NUMBER
Yes
ORG_ID NUMBER

TASK_ID NUMBER

SCHEDULED_ARRIVAL_DATE DATE

SHIPPING_METHOD_CODE VARCHAR2 (30)
ORDER_SOURCE_ID NUMBER

ACTUAL_SHIPMENT_DATE DATE

FULFILLMENT_DATE DATE

FLOW_STATUS_CODE VARCHAR2 (30)
RECEIVED_QTY NUMBER

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 (80) Yes
INVENTORY_ITEM_ID NUMBER
Yes
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ACCESS_ID
,      LINE_ID
,      HEADER_ID
,      LINE_NUMBER
,      ORG_ID
,      TASK_ID
,      SCHEDULED_ARRIVAL_DATE
,      SHIPPING_METHOD_CODE
,      ORDER_SOURCE_ID
,      ACTUAL_SHIPMENT_DATE
,      FULFILLMENT_DATE
,      FLOW_STATUS_CODE
,      RECEIVED_QTY
,      ORDER_STATUS
,      ORDERED_QUANTITY
,      SHIPPED_QUANTITY
,      SOURCE_ORG_ID
,      SOURCE_SUBINV
,      CANCELLED_QUANTITY
,      SHIPMENT_NUM
,      SHIP_METHOD_MEANING
,      INVENTORY_ITEM_ID
FROM APPS.CSM_ORDER_LINES_V;

Dependencies

[top of page]

APPS.CSM_ORDER_LINES_V references the following:

SchemaAPPS
PL/SQL PackageASG_BASE - show dependent code
SynonymCSM_REQ_LINE_DETAILS_ACC
PL/SQL PackageCSP_PICK_UTILS - show dependent code
SynonymCSP_REQ_LINE_DETAILS
SynonymFND_LOOKUP_VALUES
SynonymOE_ORDER_LINES_ALL
SynonymRCV_SHIPMENT_HEADERS
SynonymRCV_SHIPMENT_LINES

APPS.CSM_ORDER_LINES_V is not referenced by any database object