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

VIEW: APPS.OE_WIP_OPEN_DEMANDS_V

Object Details
Object Name: OE_WIP_OPEN_DEMANDS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewONT.OE_WIP_OPEN_DEMANDS_V
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 Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER

Ship from organization id -warehouse
DEMAND_ORDER_HEADER_ID NUMBER
Yes Foreign key refernence to OE_ORDER_HEADERS_ALL; the order to which this line belongs.
DEMAND_SOURCE_HEADER_ID NUMBER
Yes
DEMAND_SOURCE_LINE_ID NUMBER
Yes
DEMAND_SOURCE_LINE_NUMBER NUMBER
Yes
REQUIREMENT_DATE DATE

INVENTORY_ITEM_ID NUMBER
Yes
ITEM_TYPE_CODE VARCHAR2 (30)
DEMAND_CLASS_CODE VARCHAR2 (30)
DEMAND_UOM_CODE VARCHAR2 (3)
DEMAND_OPEN_QUANTITY NUMBER

Query Text

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


SELECT ORGANIZATION_ID
,      DEMAND_ORDER_HEADER_ID
,      DEMAND_SOURCE_HEADER_ID
,      DEMAND_SOURCE_LINE_ID
,      DEMAND_SOURCE_LINE_NUMBER
,      REQUIREMENT_DATE
,      INVENTORY_ITEM_ID
,      ITEM_TYPE_CODE
,      DEMAND_CLASS_CODE
,      DEMAND_UOM_CODE
,      DEMAND_OPEN_QUANTITY
FROM APPS.OE_WIP_OPEN_DEMANDS_V;

Dependencies

[top of page]

APPS.OE_WIP_OPEN_DEMANDS_V references the following:

SchemaAPPS
SynonymFND_LANGUAGES
PL/SQL PackageFND_PROFILE - show dependent code
SynonymMTL_SALES_ORDERS
PL/SQL PackageOE_LINE_UTIL - show dependent code
SynonymOE_ORDER_HEADERS_ALL
SynonymOE_ORDER_LINES_ALL
SynonymOE_TRANSACTION_TYPES_TL
APPS.OE_WIP_OPEN_DEMANDS_V is referenced by following:

SchemaAPPS
ViewWIP_OPEN_DEMANDS_V