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

TABLE: OPI.OPI_DBI_INTRANSIT_STG

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


Staging table for extracting Intransit 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.
INVENTORY_ITEM_ID NUMBER
Yes Inventory Item ID as in the OLTP system.
TRANSACTION_DATE DATE
Yes Transaction date.
INTRANSIT_QTY NUMBER

Intransit Inventory Quantity.
PRIMARY_UOM VARCHAR2 (3)
Primary UOM.
INTRANSIT_VALUE_B NUMBER

Intransit Inventory Value in Functional Currency.
SOURCE NUMBER
Yes Source: 1 if OPI or 2 if 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
INTRANSIT_QTY_DRAFT NUMBER

Intransit quantity in draft
INTRANSIT_VALUE_DRAFT_B NUMBER

Intransit value in draft
Query Text

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


SELECT ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      TRANSACTION_DATE
,      INTRANSIT_QTY
,      PRIMARY_UOM
,      INTRANSIT_VALUE_B
,      SOURCE
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      INTRANSIT_QTY_DRAFT
,      INTRANSIT_VALUE_DRAFT_B
FROM OPI.OPI_DBI_INTRANSIT_STG;

Dependencies

[top of page]

OPI.OPI_DBI_INTRANSIT_STG does not reference any database object

OPI.OPI_DBI_INTRANSIT_STG is referenced by following:

SchemaAPPS
SynonymOPI_DBI_INTRANSIT_STG