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

TABLE: OPI.OPI_DBI_WMS_OP_STG

Object Details
Object Name: OPI_DBI_WMS_OP_STG
Object Type: TABLE
Owner: OPI
Subobject Name:
Status: VALID


Staging table that stores the details of the Operation plans completed, since the last collection, at the Operation plan instance level.


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
OPI_DBI_WMS_OP_STG_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnOP_PLAN_INSTANCE_ID
Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER

Organization Identifier.
SUBINVENTORY_CODE VARCHAR2 (10)
Subinventory where the Operation Plan instance is completed.
INVENTORY_ITEM_ID NUMBER

Inventory Item Identifier.
OPERATION_PLAN_ID NUMBER

Operation Plan Identifier.
OP_PLAN_INSTANCE_ID NUMBER

Operation Plan Instance Identifier.
STATUS NUMBER

Final Status of Operation Plan.
PLAN_EXECUTION_START_DATE DATE

Start Date of Operation Plan Instance with Time Stamp.
PLAN_EXECUTION_END_DATE DATE

Completion Date of Operation Plan Instance with Time Stamp.
PLAN_ELAPSED_TIME NUMBER

Time taken for completion of Operation Plan Instance in number of Hours. This is calculated as (completion time-start time)* 24
Query Text

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


SELECT ORGANIZATION_ID
,      SUBINVENTORY_CODE
,      INVENTORY_ITEM_ID
,      OPERATION_PLAN_ID
,      OP_PLAN_INSTANCE_ID
,      STATUS
,      PLAN_EXECUTION_START_DATE
,      PLAN_EXECUTION_END_DATE
,      PLAN_ELAPSED_TIME
FROM OPI.OPI_DBI_WMS_OP_STG;

Dependencies

[top of page]

OPI.OPI_DBI_WMS_OP_STG does not reference any database object

OPI.OPI_DBI_WMS_OP_STG is referenced by following:

SchemaAPPS
SynonymOPI_DBI_WMS_OP_STG