[Home] [Help] [Dependency Information]
Object Name: | OPI_DBI_OPM_WIP_TST_PRIOR |
---|---|
Object Type: | TABLE |
Owner: | OPI |
Subobject Name: | |
Status: | VALID |
Work table used in the process of summarization of the Inventory Management reports' WIP Value measure.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORGN_CODE | VARCHAR2 | (4) | Organization Code. | |
ITEM_ID | NUMBER | Item ID. | ||
GL_TRANS_DATE | DATE | Transaction Date. | ||
TRANS_QTY | NUMBER | Transaction Quantity. | ||
AMOUNT_BASE | NUMBER | Transaction Value. |
Cut, paste (and edit) the following text to query this object:
SELECT ORGN_CODE
, ITEM_ID
, GL_TRANS_DATE
, TRANS_QTY
, AMOUNT_BASE
FROM OPI.OPI_DBI_OPM_WIP_TST_PRIOR;
OPI.OPI_DBI_OPM_WIP_TST_PRIOR does not reference any database object
OPI.OPI_DBI_OPM_WIP_TST_PRIOR is referenced by following:
|
|
|