[Home] [Help] [Dependency Information]
Object Name: | OPI_DBI_WMS_OP_F |
---|---|
Object Type: | TABLE |
Owner: | OPI |
Subobject Name: | |
Status: | VALID |
Fact table that stores data pertaining to the Operation Plans in the warehouse at the Operation Plan Instance Level.
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OPI_DBI_WMS_OP_F_N1 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY |
INVENTORY_ITEM_ID
ORGANIZATION_ID SUBINVENTORY_CODE OPERATION_PLAN_ID PLAN_EXECUTION_END_DATE STATUS |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORGANIZATION_ID | NUMBER | Organization Identifier. | ||
SUBINVENTORY_CODE | VARCHAR2 | (10) | Subinventory where Operation Plan instance is completed. | |
INVENTORY_ITEM_ID | NUMBER | Inventory Item Identifier. | ||
OPERATION_PLAN_ID | NUMBER | Operation Plan Identifier. | ||
PLAN_EXECUTION_END_DATE | DATE | Completion Date of Operation Plan Instance (without time stamp). | ||
PLAN_ELAPSED_TIME | NUMBER | Time taken for completion of Operation Plan Instance in number of Hours. . | ||
STATUS | NUMBER | Final Status of Operation Plan. | ||
EXECUTIONS | NUMBER | Total executions of Operation Plan. | ||
EXECUTIONS_WITH_EXCEPTIONS | NUMBER | Number of Executions with exceptions. | ||
EXCEPTIONS | NUMBER | Total number of exceptions recorded for executions. | ||
CREATION_DATE | DATE | Yes | Standard WHO column. | |
LAST_UPDATE_DATE | DATE | Yes | Standard WHO column. | |
CREATED_BY | NUMBER | Yes | Standard WHO column. | |
LAST_UPDATED_BY | NUMBER | Yes | Standard WHO column. | |
LAST_UPDATE_LOGIN | NUMBER | Yes | Standard WHO column. | |
REQUEST_ID | NUMBER | Standard WHO column. | ||
PROGRAM_APPLICATION_ID | NUMBER | Standard WHO column. | ||
PROGRAM_ID | NUMBER | Standard WHO column. | ||
PROGRAM_UPDATE_DATE | DATE | Standard WHO column. |
Cut, paste (and edit) the following text to query this object:
SELECT ORGANIZATION_ID
, SUBINVENTORY_CODE
, INVENTORY_ITEM_ID
, OPERATION_PLAN_ID
, PLAN_EXECUTION_END_DATE
, PLAN_ELAPSED_TIME
, STATUS
, EXECUTIONS
, EXECUTIONS_WITH_EXCEPTIONS
, EXCEPTIONS
, CREATION_DATE
, LAST_UPDATE_DATE
, CREATED_BY
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
FROM OPI.OPI_DBI_WMS_OP_F;
OPI.OPI_DBI_WMS_OP_F does not reference any database object
OPI.OPI_DBI_WMS_OP_F is referenced by following:
|
|
|