eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: OPI.OPI_DBI_WMS_TASKS_STG

Object Details

Object Name:	OPI_DBI_WMS_TASKS_STG
Object Type:	TABLE
Owner:	OPI
FND Design Data:	OPI.OPI_DBI_WMS_TASKS_STG
Subobject Name:
Status:	VALID

Storage Details

Tablespace:
PCT Free:
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OPI_DBI_WMS_TASKS_STG_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TASK_TYPE TRANSACTION_TEMP_ID
OPI_DBI_WMS_TASKS_STG_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TASK_TYPE IS_PARENT

Columns

Name	Datatype	Length
TASK_ID	NUMBER
ORGANIZATION_ID	NUMBER
INVENTORY_ITEM_ID	NUMBER
TASK_TYPE	NUMBER
COMPLETION_DATE	DATE
OP_PLAN_INSTANCE_ID	NUMBER
IS_PARENT	VARCHAR2	(5)
SUBINVENTORY_CODE	VARCHAR2	(10)
TRANSACTION_TEMP_ID	NUMBER

Query Text

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


SELECT TASK_ID
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      TASK_TYPE
,      COMPLETION_DATE
,      OP_PLAN_INSTANCE_ID
,      IS_PARENT
,      SUBINVENTORY_CODE
,      TRANSACTION_TEMP_ID
FROM OPI.OPI_DBI_WMS_TASKS_STG;

Dependencies

[top of page]

OPI.OPI_DBI_WMS_TASKS_STG does not reference any database object

OPI.OPI_DBI_WMS_TASKS_STG is referenced by following:

APPS: OPI_DBI_WMS_TASKS_STG