[Home] [Help] [Dependency Information]
Object Name: | SO_LINES_CURRENT_DEMAND_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OE.SO_LINES_CURRENT_DEMAND_V |
Subobject Name: | |
Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORDER_NUMBER | NUMBER | Yes | ||
ORDER_TYPE_ID | NUMBER | Yes | ||
CUSTOMER_ID | NUMBER | |||
ORIGINAL_SYSTEM_REFERENCE | VARCHAR2 | (50) | ||
ORDER_TYPE_NAME | VARCHAR2 | (30) | Yes | |
LINE_ID | NUMBER | Yes | ||
LINE_NUMBER | NUMBER | |||
SHIPMENT_NUMBER | NUMBER | |||
OPTION_NUMBER | NUMBER | |||
ORIGINAL_SYSTEM_LINE_REFERENCE | VARCHAR2 | (50) | ||
HEADER_ID | NUMBER | Yes | ||
DEMAND_STREAM_ID | NUMBER | |||
DATE_REQUESTED_CURRENT | DATE | |||
PARENT_LINE_ID | NUMBER | |||
ATO_LINE_ID | NUMBER | |||
INVENTORY_ITEM_ID | NUMBER | Yes | ||
ITEM_TYPE_CODE | VARCHAR2 | (30) | Yes | |
OPEN_FLAG | VARCHAR2 | (1) | ||
ATO_FLAG | VARCHAR2 | (1) | ||
PICK_RELEASE_STATUS | NUMBER | |||
SHIP_CONFIRM_STATUS | NUMBER | |||
MFG_RELEASE_STATUS | NUMBER | |||
SERVICE_INTERFACE_STATUS | NUMBER | |||
ORDERED_QUANTITY | NUMBER | |||
CANCELLED_QUANTITY | NUMBER | |||
SHIPPED_QUANTITY | NUMBER | |||
INVOICED_QUANTITY | NUMBER | |||
PICK_RELEASED_QUANTITY | NUMBER | |||
OPEN_BACKORDERED_QUANTITY | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT ORDER_NUMBER
, ORDER_TYPE_ID
, CUSTOMER_ID
, ORIGINAL_SYSTEM_REFERENCE
, ORDER_TYPE_NAME
, LINE_ID
, LINE_NUMBER
, SHIPMENT_NUMBER
, OPTION_NUMBER
, ORIGINAL_SYSTEM_LINE_REFERENCE
, HEADER_ID
, DEMAND_STREAM_ID
, DATE_REQUESTED_CURRENT
, PARENT_LINE_ID
, ATO_LINE_ID
, INVENTORY_ITEM_ID
, ITEM_TYPE_CODE
, OPEN_FLAG
, ATO_FLAG
, PICK_RELEASE_STATUS
, SHIP_CONFIRM_STATUS
, MFG_RELEASE_STATUS
, SERVICE_INTERFACE_STATUS
, ORDERED_QUANTITY
, CANCELLED_QUANTITY
, SHIPPED_QUANTITY
, INVOICED_QUANTITY
, PICK_RELEASED_QUANTITY
, OPEN_BACKORDERED_QUANTITY
FROM APPS.SO_LINES_CURRENT_DEMAND_V;
APPS.SO_LINES_CURRENT_DEMAND_V is not referenced by any database object
|
|
|