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

VIEW: APPS.WIP_OPEN_DEMANDS_V

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

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
Query Text

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;

Dependencies

[top of page]

APPS.WIP_OPEN_DEMANDS_V references the following:

SchemaAPPS
PL/SQL PackageFND_PROFILE - show dependent code
PL/SQL PackageINV_CONVERT - show dependent code
SynonymMTL_SYSTEM_ITEMS
PL/SQL PackageOE_LINE_UTIL - show dependent code
ViewOE_WIP_OPEN_DEMANDS_V
APPS.WIP_OPEN_DEMANDS_V is referenced by following:

SchemaAPPS
Package BodyWIP_SO_RESERVATIONS - show dependent code