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

TABLE: OPI.OPI_DBI_WMS_EX_STG

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


Staging table that stores the details of all the exceptions encountered in the warehouse for picks and Operation plans.


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
OPI_DBI_WMS_EX_STG_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnOPERATION_PLAN_INDICATOR
ColumnOP_PLAN_INSTANCE_ID
OPI_DBI_WMS_EX_STG_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnOPERATION_PLAN_INDICATOR
ColumnTASK_ID
Columns
Name Datatype Length Mandatory Comments
EXCEPTION_ID NUMBER

Unique Identifier for the Exception.
TASK_ID NUMBER

Transaction Temp ID value from WDTH table.
ORGANIZATION_ID NUMBER

Organization Identifier.
INVENTORY_ITEM_ID NUMBER

Inventory Item Identifier.
SUBINVENTORY_CODE VARCHAR2 (10)
Subinventory Code.
OPERATION_PLAN_ID NUMBER

Operation Plan Identifier. This value is NULL for Outbound Tasks.
OPERATION_PLAN_INDICATOR NUMBER

Operation Plan Flag to identify Outbound and Inbound Task Exceptions.Outbound 1 Inbound 2.
OPERATION_PLAN_STATUS NUMBER

Final Status of Operation Plan.
OP_PLAN_INSTANCE_ID NUMBER

Operation Plan Instance ID
COMPLETION_DATE DATE

Task/Operation Plan Execution Completion Date.
REASON_ID NUMBER

Exception reason.
Query Text

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


SELECT EXCEPTION_ID
,      TASK_ID
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      SUBINVENTORY_CODE
,      OPERATION_PLAN_ID
,      OPERATION_PLAN_INDICATOR
,      OPERATION_PLAN_STATUS
,      OP_PLAN_INSTANCE_ID
,      COMPLETION_DATE
,      REASON_ID
FROM OPI.OPI_DBI_WMS_EX_STG;

Dependencies

[top of page]

OPI.OPI_DBI_WMS_EX_STG does not reference any database object

OPI.OPI_DBI_WMS_EX_STG is referenced by following:

SchemaAPPS
SynonymOPI_DBI_WMS_EX_STG