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


VIEW: APPS.WSM_RESERVATIONS_V

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

View Type

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.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
RESERVATION_ID NUMBER
Yes
ORGANIZATION_ID NUMBER
Yes
DEMAND_SOURCE_TYPE_ID NUMBER
Yes
DEMAND_SOURCE_NAME VARCHAR2 (30)
DEMAND_SOURCE_HEADER_ID NUMBER

DEMAND_SOURCE_LINE_ID NUMBER

DEMAND_SOURCE_LINE_NUMBER VARCHAR2 (122)
ORDER_TYPE VARCHAR2 (30) Yes
CUSTOMER_NUMBER VARCHAR2 (30) Yes
CUSTOMER_NAME VARCHAR2 (360) Yes
DEMAND_CLASS_CODE VARCHAR2 (30)
REQUIREMENT_DATE DATE
Yes
INVENTORY_ITEM_ID NUMBER
Yes
ITEM_REVISION VARCHAR2 (3)
SUBINVENTORY_CODE VARCHAR2 (10)
LOCATOR_ID NUMBER

LOT_NUMBER VARCHAR2 (80)
SERIAL_NUMBER VARCHAR2 (30)
PRIMARY_UOM_CODE VARCHAR2 (3)
PRIMARY_QUANTITY NUMBER
Yes
RESERVATION_UOM_CODE VARCHAR2 (3)
RESERVATION_QUANTITY NUMBER
Yes
ORDER_QUANTITY_UOM VARCHAR2 (3)
WIP_ENTITY_ID NUMBER

LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER

LAST_UPDATE_LOGIN NUMBER

REQUEST_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

Query Text

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


SELECT ROW_ID
,      RESERVATION_ID
,      ORGANIZATION_ID
,      DEMAND_SOURCE_TYPE_ID
,      DEMAND_SOURCE_NAME
,      DEMAND_SOURCE_HEADER_ID
,      DEMAND_SOURCE_LINE_ID
,      DEMAND_SOURCE_LINE_NUMBER
,      ORDER_TYPE
,      CUSTOMER_NUMBER
,      CUSTOMER_NAME
,      DEMAND_CLASS_CODE
,      REQUIREMENT_DATE
,      INVENTORY_ITEM_ID
,      ITEM_REVISION
,      SUBINVENTORY_CODE
,      LOCATOR_ID
,      LOT_NUMBER
,      SERIAL_NUMBER
,      PRIMARY_UOM_CODE
,      PRIMARY_QUANTITY
,      RESERVATION_UOM_CODE
,      RESERVATION_QUANTITY
,      ORDER_QUANTITY_UOM
,      WIP_ENTITY_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM APPS.WSM_RESERVATIONS_V;

Dependencies

[top of page]

APPS.WSM_RESERVATIONS_V references the following:

SchemaAPPS
SynonymHZ_CUST_ACCOUNTS
SynonymHZ_PARTIES
SynonymMTL_RESERVATIONS
SynonymMTL_SALES_ORDERS
SynonymOE_ORDER_LINES_ALL
SynonymOE_TRANSACTION_TYPES_ALL
APPS.WSM_RESERVATIONS_V is referenced by following:

SchemaAPPS
Package BodyWSM_RESERVATIONS_PVT - show dependent code