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

TABLE: OPI.OPI_DBI_WIP_STG

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


Staging table for WIP Inventory Value for DBI Inventory Value reports.


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER
Yes Organization id as in the OLTP system.
INVENTORY_ITEM_ID NUMBER
Yes Inventory Item id as in the OLTP system.
TRANSACTION_DATE DATE
Yes Date of WIP transaction.
PRIMARY_UOM VARCHAR2 (3)
Primary UOM code for item transacted.
WIP_VALUE_B NUMBER

Value of WIP transaction in functional currency.
SOURCE NUMBER
Yes Data source. 1 = OPI, 1 = OPM.
CREATION_DATE DATE

Obsoleted. Staging Tables do not need standard who columns
LAST_UPDATE_DATE DATE

Obsoleted. Staging Tables do not need standard who columns
CREATED_BY NUMBER

Obsoleted. Staging Tables do not need standard who columns
LAST_UPDATED_BY NUMBER

Obsoleted. Staging Tables do not need standard who columns
LAST_UPDATE_LOGIN NUMBER

Obsoleted. Staging Tables do not need standard who columns
WIP_VALUE_B_DRAFT NUMBER

Work in progress value in draft mode. Used only for process organizations
Query Text

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


SELECT ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      TRANSACTION_DATE
,      PRIMARY_UOM
,      WIP_VALUE_B
,      SOURCE
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      WIP_VALUE_B_DRAFT
FROM OPI.OPI_DBI_WIP_STG;

Dependencies

[top of page]

OPI.OPI_DBI_WIP_STG does not reference any database object

OPI.OPI_DBI_WIP_STG is referenced by following:

SchemaAPPS
SynonymOPI_DBI_WIP_STG