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_CCA_STG

Object Details

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

Staging table for extraction of inventory cycle count accuracy and adjustment data.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
ORGANIZATION_ID	NUMBER		Yes	Organization ID for organization to which the cycle count entry belongs.
INVENTORY_ITEM_ID	NUMBER		Yes	Inventory Item ID of item for which the cycle count entry was created.
CYCLE_COUNT_HEADER_ID	NUMBER		Yes	Internal ID for the cycle count to which the entry belongs.
ABC_CLASS_ID	VARCHAR2	(40)	Yes	ABC class ID to which this item was assigned for the cycle count.
SUBINVENTORY_CODE	VARCHAR2	(10)	Yes	Subinventory to which the count entry is associated.
CYCLE_COUNT_ENTRY_ID	VARCHAR2	(40)	Yes	Entry ID for the cycle count entry. Primary key for this table and foreign key to MTL_CYCLE_COUNT_ENTRIES.
SOURCE	NUMBER		Yes	Data source. 1 = OPI, 2 = OPM.
APPROVAL_DATE	DATE		Yes	Date on which the cycle count entry was approved.
UOM_CODE	VARCHAR2	(3)	Yes	Primary UOM for this Item/Organization combination.
SYSTEM_INVENTORY_QTY	NUMBER			Counted system quantity for the entry in the primary UOM.
POSITIVE_ADJUSTMENT_QTY	NUMBER			Quantity of adjustment (if greater than 0).
NEGATIVE_ADJUSTMENT_QTY	NUMBER			Quantity of adjustment (if less than 0).
ITEM_UNIT_COST	NUMBER			Item cost of one unit in the primary UOM at the time of the cycle count entry.
ITEM_ADJ_UNIT_COST	NUMBER			Item cost of one unit in the primary UOM at the time of when the adjustment was costed.
HIT_MISS_POS	NUMBER			Positive Hit/Miss tolerance.
HIT_MISS_NEG	NUMBER			Negative Hit/Miss tolerance.
EXACT_MATCH	NUMBER			Exact match marker. 0 = not a match, 1 = exact match.

Query Text

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


SELECT ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      CYCLE_COUNT_HEADER_ID
,      ABC_CLASS_ID
,      SUBINVENTORY_CODE
,      CYCLE_COUNT_ENTRY_ID
,      SOURCE
,      APPROVAL_DATE
,      UOM_CODE
,      SYSTEM_INVENTORY_QTY
,      POSITIVE_ADJUSTMENT_QTY
,      NEGATIVE_ADJUSTMENT_QTY
,      ITEM_UNIT_COST
,      ITEM_ADJ_UNIT_COST
,      HIT_MISS_POS
,      HIT_MISS_NEG
,      EXACT_MATCH
FROM OPI.OPI_DBI_INV_CCA_STG;

Dependencies

[top of page]

OPI.OPI_DBI_INV_CCA_STG does not reference any database object

OPI.OPI_DBI_INV_CCA_STG is referenced by following:

APPS: OPI_DBI_INV_CCA_STG