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

TABLE: OPI.OPI_DBI_ONHAND_STG

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


Staging table for extracting On Hand Inventory Activities.


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.
SUBINVENTORY_CODE VARCHAR2 (240)
Subinventory Code as in the OLTP system.
INVENTORY_ITEM_ID NUMBER
Yes Inventory Item ID as in the OLTP system.
TRANSACTION_DATE DATE
Yes Transaction date.
ONHAND_QTY NUMBER

For discrete orgs it stores total quantity. For process orgs stores quantity from records posted to final ledger.
PRIMARY_UOM VARCHAR2 (3)
Primary UOM.
ONHAND_VALUE_B NUMBER

For discrete orgs it stores total value. For process orgs stores value from records posted to final ledger.
SOURCE NUMBER
Yes 1 for discrete orgs, 2 for process orgs, 3 for OPM preR12 data and 4 for period close process records
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
ONHAND_QTY_DRAFT NUMBER

For discrete orgs it is not used. For process orgs stores quantity from records posted to draft ledger.
ONHAND_VALUE_B_DRAFT NUMBER

For discrete orgs it is not used. For process orgs stores value from records posted to draft ledger.
WIP_VALUE_B NUMBER

For discrete orgs it stores total wip value. For process orgs stores value from records posted to final ledger.
WIP_VALUE_B_DRAFT NUMBER

For discrete orgs it is not used. For process orgs stores value from records posted to draft ledger.
TRANSACTION_SOURCE VARCHAR2 (30)
MTA, MMT, WTA, GTV, MOQ, WPB depending upon from which table data is inserted in this table. MOQ, WPB are used only in initial load.
PUSH_TO_FACT_FLAG VARCHAR2 (1)
Use only in initial load
Query Text

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


SELECT ORGANIZATION_ID
,      SUBINVENTORY_CODE
,      INVENTORY_ITEM_ID
,      TRANSACTION_DATE
,      ONHAND_QTY
,      PRIMARY_UOM
,      ONHAND_VALUE_B
,      SOURCE
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      ONHAND_QTY_DRAFT
,      ONHAND_VALUE_B_DRAFT
,      WIP_VALUE_B
,      WIP_VALUE_B_DRAFT
,      TRANSACTION_SOURCE
,      PUSH_TO_FACT_FLAG
FROM OPI.OPI_DBI_ONHAND_STG;

Dependencies

[top of page]

OPI.OPI_DBI_ONHAND_STG does not reference any database object

OPI.OPI_DBI_ONHAND_STG is referenced by following:

SchemaAPPS
SynonymOPI_DBI_ONHAND_STG