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

VIEW: MRP.MRP_RESERVATIONS#

Object Details
Object Name: MRP_RESERVATIONS#
Object Type: VIEW
Owner: MRP
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
TRANSACTION_ID NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_LOGIN NUMBER

INVENTORY_ITEM_ID NUMBER
Yes
COMPILE_DESIGNATOR VARCHAR2 (10) Yes
ORGANIZATION_ID NUMBER
Yes
RESERVATION_DATE DATE
Yes
REQUIREMENT_DATE DATE
Yes
RESERVED_QUANTITY NUMBER
Yes
NONNET_QUANTITY_RESERVED NUMBER
Yes
DISPOSITION_TYPE NUMBER
Yes
DISPOSITION_ID NUMBER
Yes
PARENT_DEMAND_ID NUMBER
Yes
SUBINVENTORY VARCHAR2 (10)
DEMAND_CLASS VARCHAR2 (30)
REVISION VARCHAR2 (3)
REQUEST_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

PROJECT_ID NUMBER (15)
TASK_ID NUMBER (15)
PLANNING_GROUP VARCHAR2 (30)
Query Text

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


SELECT TRANSACTION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      INVENTORY_ITEM_ID
,      COMPILE_DESIGNATOR
,      ORGANIZATION_ID
,      RESERVATION_DATE
,      REQUIREMENT_DATE
,      RESERVED_QUANTITY
,      NONNET_QUANTITY_RESERVED
,      DISPOSITION_TYPE
,      DISPOSITION_ID
,      PARENT_DEMAND_ID
,      SUBINVENTORY
,      DEMAND_CLASS
,      REVISION
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      PROJECT_ID
,      TASK_ID
,      PLANNING_GROUP
FROM MRP.MRP_RESERVATIONS#;

Dependencies

[top of page]

MRP.MRP_RESERVATIONS# references the following:

SchemaMRP
TableMRP_RESERVATIONS
MRP.MRP_RESERVATIONS# is referenced by following:

SchemaAPPS
SynonymMRP_RESERVATIONS