[Home] [Help] [Dependency Information]
Object Name: | WIP_OPEN_DEMANDS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | WIP.WIP_OPEN_DEMANDS_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORGANIZATION_ID | NUMBER | |||
DEMAND_SOURCE_HEADER_ID | NUMBER | Yes | ||
DEMAND_ORDER_HEADER_ID | NUMBER | Yes | ||
DEMAND_SOURCE_LINE_ID | NUMBER | Yes | ||
DEMAND_SOURCE_LINE_NUMBER | NUMBER | Yes | ||
REQUIREMENT_DATE | DATE | |||
INVENTORY_ITEM_ID | NUMBER | Yes | ||
DEMAND_CLASS_CODE | VARCHAR2 | (30) | ||
DEMAND_UOM_CODE | VARCHAR2 | (3) | ||
DEMAND_OPEN_QUANTITY | NUMBER | |||
PRIMARY_UOM_CODE | VARCHAR2 | (3) | ||
PRIMARY_OPEN_QUANTITY | NUMBER | |||
REPLENISH_TO_ORDER_FLAG | VARCHAR2 | (1) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT ORGANIZATION_ID
, DEMAND_SOURCE_HEADER_ID
, DEMAND_ORDER_HEADER_ID
, DEMAND_SOURCE_LINE_ID
, DEMAND_SOURCE_LINE_NUMBER
, REQUIREMENT_DATE
, INVENTORY_ITEM_ID
, DEMAND_CLASS_CODE
, DEMAND_UOM_CODE
, DEMAND_OPEN_QUANTITY
, PRIMARY_UOM_CODE
, PRIMARY_OPEN_QUANTITY
, REPLENISH_TO_ORDER_FLAG
FROM APPS.WIP_OPEN_DEMANDS_V;
|
|
|