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

TABLE: OPI.OPI_DBI_ONH_QTY_STG

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


Staging table that stores Onhand Quantity for process and discrete organizations from MMT.


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER

Organization identifier
INVENTORY_ITEM_ID NUMBER

Inventory item identifier
SUBINVENTORY_CODE VARCHAR2 (10)
Subinventory code
COST_GROUP_ID NUMBER

Cost group identifier
TRANSACTION_DATE DATE

Transaction date
ONHAND_QTY NUMBER

Onhand quantity
ONHAND_QTY_DRAFT NUMBER

Onhand quantity from draft posted records in process organizations
SOURCE NUMBER

Indicates source of data, 1 for discrete orgs, 2 for process orgs, 3 for process org pre R12, 4 for CPCS records
TRANSACTION_SOURCE VARCHAR2 (30)
Indicates primarily from which transaction table the data is sourced.Various values it can have are:MOQ and MMT
PUSH_TO_FACT_FLAG VARCHAR2 (1)
Indicates if the record should be pused to fact or not. Valid for Initial load only.
Query Text

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


SELECT ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      SUBINVENTORY_CODE
,      COST_GROUP_ID
,      TRANSACTION_DATE
,      ONHAND_QTY
,      ONHAND_QTY_DRAFT
,      SOURCE
,      TRANSACTION_SOURCE
,      PUSH_TO_FACT_FLAG
FROM OPI.OPI_DBI_ONH_QTY_STG;

Dependencies

[top of page]

OPI.OPI_DBI_ONH_QTY_STG does not reference any database object

OPI.OPI_DBI_ONH_QTY_STG is referenced by following:

SchemaAPPS
SynonymOPI_DBI_ONH_QTY_STG