eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: OPI.OPI_DBI_INV_VALUE_F

Object Details

Object Name:	OPI_DBI_INV_VALUE_F
Object Type:	TABLE
Owner:	OPI
Subobject Name:
Status:	VALID

Base table for collecting On Hand, WIP and Intransit Inventory Activities.

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OPI_DBI_INV_VALUE_F_U1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	ORGANIZATION_ID SUBINVENTORY_CODE INVENTORY_ITEM_ID TRANSACTION_DATE

Columns

Name	Datatype	Length	Mandatory	Comments
OPERATING_UNIT_ID	NUMBER			Column Obsoleted - Not in use
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			On Hand Inventory Quantity.
INTRANSIT_QTY	NUMBER			Intransit Inventory Quantity.
PRIMARY_UOM	VARCHAR2	(3)		Primary UOM.
ONHAND_VALUE_B	NUMBER			On Hand Inventory Value in Functional Currency.
INTRANSIT_VALUE_B	NUMBER			Intransit Inventory Value in Functional Currency.
WIP_VALUE_B	NUMBER			Work In Process Inventory Value in Functional Currency.
CONVERSION_RATE	NUMBER			Rate to convert from Functional Currency to DBI Global Currency.
SOURCE	NUMBER		Yes	Indicates source of data, 1 for discrete orgs, 2 for process orgs, 3 for process org pre R12, 4 for CPCS records
CREATION_DATE	DATE		Yes	Creation Date.
LAST_UPDATE_DATE	DATE		Yes	Last Update Date.
CREATED_BY	NUMBER		Yes	Standard WHO column.
LAST_UPDATED_BY	NUMBER		Yes	Standard WHO column.
LAST_UPDATE_LOGIN	NUMBER			Standard WHO column.
SEC_CONVERSION_RATE	NUMBER			Conversion rate of Secondary Currency
ONHAND_QTY_DRAFT	NUMBER			Onhand quantiry from draft posted records for process organizations.
INTRANSIT_QTY_DRAFT	NUMBER			Intransit quantity from draft posted records in process organizations
ONHAND_VALUE_B_DRAFT	NUMBER			Onhand value from draft posted records in process organizations
INTRANSIT_VALUE_B_DRAFT	NUMBER			Intransit value from draft posted records in process organizations
WIP_VALUE_B_DRAFT	NUMBER			Wip Value from draft posted records in process organizations

Query Text

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


SELECT OPERATING_UNIT_ID
,      ORGANIZATION_ID
,      SUBINVENTORY_CODE
,      INVENTORY_ITEM_ID
,      TRANSACTION_DATE
,      ONHAND_QTY
,      INTRANSIT_QTY
,      PRIMARY_UOM
,      ONHAND_VALUE_B
,      INTRANSIT_VALUE_B
,      WIP_VALUE_B
,      CONVERSION_RATE
,      SOURCE
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      SEC_CONVERSION_RATE
,      ONHAND_QTY_DRAFT
,      INTRANSIT_QTY_DRAFT
,      ONHAND_VALUE_B_DRAFT
,      INTRANSIT_VALUE_B_DRAFT
,      WIP_VALUE_B_DRAFT
FROM OPI.OPI_DBI_INV_VALUE_F;

Dependencies

[top of page]

OPI.OPI_DBI_INV_VALUE_F does not reference any database object

OPI.OPI_DBI_INV_VALUE_F is referenced by following:

APPS: ENI_DBI_INV_BASE_MV; ISC_FS_016_MV; OPI_DBI_INV_VALUE_F; OPI_INV_VAL_SUM_MV; OPI_WMS_004_MV