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

TABLE: GMO.GMO_DISPENSING_PLANNING

Object Details
Object Name: GMO_DISPENSING_PLANNING
Object Type: TABLE
Owner: GMO
FND Design Data: TableGMO.GMO_DISPENSING_PLANNING
Subobject Name:
Status: VALID


Dispense Planning Table


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
GMO_DISPENSING_PLANNING_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPLANNED_TASK_ID
GMO_DISPENSING_PLANNING_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnDISPENSE_ID
ColumnDISPENSED_DATE
Columns
Name Datatype Length Mandatory Comments
PLANNED_TASK_ID NUMBER
Yes Primary key storing the planned id
RESERVATION_ID NUMBER
Yes Reservation id
DISPENSE_AREA_ID NUMBER

Id for Dispense Area
PRIORITY VARCHAR2 (15)
Priority : High,Medium,Low
PLANNED_DISPENSING_DATE DATE

Planned Dispense Date
STATUS VARCHAR2 (15)
Status : PLANNED,DISPENSD,REVRDISP
DISPENSE_ID NUMBER

Dispensing id if dispensed
DISPENSED_DATE DATE

Dispensed_date if dispensed
OPER_ID NUMBER

Person ID
CREATED_BY NUMBER
Yes Standard who column
CREATION_DATE DATE
Yes Standard who column
LAST_UPDATED_BY NUMBER
Yes Standard who column
LAST_UPDATE_DATE DATE
Yes Standard who column
LAST_UPDATE_LOGIN NUMBER

Standard who column
Query Text

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


SELECT PLANNED_TASK_ID
,      RESERVATION_ID
,      DISPENSE_AREA_ID
,      PRIORITY
,      PLANNED_DISPENSING_DATE
,      STATUS
,      DISPENSE_ID
,      DISPENSED_DATE
,      OPER_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM GMO.GMO_DISPENSING_PLANNING;

Dependencies

[top of page]

GMO.GMO_DISPENSING_PLANNING does not reference any database object

GMO.GMO_DISPENSING_PLANNING is referenced by following:

SchemaGMO
ViewGMO_DISPENSING_PLANNING#