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_F

Object Details

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

Stores inventory cycle count accuracy and adjustment activity.

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OPI_DBI_INV_CCA_F_U1	NORMAL	UNIQUE	APPS_TS_SUMMARY	CYCLE_COUNT_ENTRY_ID SUBINVENTORY_CODE SOURCE

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.
SYSTEM_INVENTORY_VAL_B	NUMBER			System Inventory value in the organization''s functional currency.
SYSTEM_INVENTORY_VAL_G	NUMBER			System Inventory value in the global currency.
POSITIVE_ADJUSTMENT_QTY	NUMBER			Quantity of adjustment (if greater than 0).
POSITIVE_ADJUSTMENT_VAL_B	NUMBER			Positive Adjustment value in the organization''s functional currency (if the adjustment quantity > 0).
POSITIVE_ADJUSTMENT_VAL_G	NUMBER			Positive Adjustment value in the global currency (if the adjustment quantity > 0).
NEGATIVE_ADJUSTMENT_QTY	NUMBER			Quantity of adjustment (if less than 0).
NEGATIVE_ADJUSTMENT_VAL_B	NUMBER			Positive Adjustment value in the organization''s functional currency (if the adjustment quantity < 0).
NEGATIVE_ADJUSTMENT_VAL_G	NUMBER			Positive Adjustment value in the global currency (if the adjustment quantity < 0).
CONVERSION_RATE	NUMBER			Conversion rate between the organization''s functional currency and the global currency.
ITEM_UNIT_COST	NUMBER			Item cost of one unit in the primary UOM at the time of cycle count entry.
HIT_OR_MISS	NUMBER			Hit/Miss marker. 0 = Miss, 1 = Hit.
EXACT_MATCH	NUMBER			Exact match marker. 0 = not a match, 1 = exact match.
LAST_UPDATE_DATE	DATE			Standard Who column.
LAST_UPDATED_BY	NUMBER			Standard Who column.
LAST_UPDATE_LOGIN	NUMBER			Standard Who column.
CREATION_DATE	DATE			Standard Who column.
CREATED_BY	NUMBER			Standard Who column.
REQUEST_ID	NUMBER	(15)		Standard Who column.
PROGRAM_APPLICATION_ID	NUMBER	(15)		Standard Who column.
PROGRAM_ID	NUMBER	(15)		Standard Who column.
PROGRAM_UPDATE_DATE	DATE			Standard Who column.
SYSTEM_INVENTORY_VAL_SG	NUMBER			System Inventory Value in secondary global currency
POSITIVE_ADJUSTMENT_VAL_SG	NUMBER			Value of Positive Adjustments in secondary global currency
NEGATIVE_ADJUSTMENT_VAL_SG	NUMBER			Value of Negative Adjustment in secondary global currency
SEC_CONVERSION_RATE	NUMBER			Conversion rate of secondary global currency

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
,      SYSTEM_INVENTORY_VAL_B
,      SYSTEM_INVENTORY_VAL_G
,      POSITIVE_ADJUSTMENT_QTY
,      POSITIVE_ADJUSTMENT_VAL_B
,      POSITIVE_ADJUSTMENT_VAL_G
,      NEGATIVE_ADJUSTMENT_QTY
,      NEGATIVE_ADJUSTMENT_VAL_B
,      NEGATIVE_ADJUSTMENT_VAL_G
,      CONVERSION_RATE
,      ITEM_UNIT_COST
,      HIT_OR_MISS
,      EXACT_MATCH
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      SYSTEM_INVENTORY_VAL_SG
,      POSITIVE_ADJUSTMENT_VAL_SG
,      NEGATIVE_ADJUSTMENT_VAL_SG
,      SEC_CONVERSION_RATE
FROM OPI.OPI_DBI_INV_CCA_F;

Dependencies

[top of page]

OPI.OPI_DBI_INV_CCA_F does not reference any database object

OPI.OPI_DBI_INV_CCA_F is referenced by following:

APPS: OPI_DBI_INV_CCA_F; OPI_INV_CCA_SUM_MV