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: APPS.OPI_INV_CCA_SUM_MV

Object Details

Object Name:	OPI_INV_CCA_SUM_MV
Object Type:	TABLE
Owner:	APPS
FND Design Data:	FND.OPI_INV_CCA_SUM_MV
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
I_SNAP$_OPI_INV_CCA_SUM_MV	FUNCTION-BASED NORMAL	UNIQUE	APPS_TS_SUMMARY	SYS_OP_MAP_NONNULL("ORGANIZATION_ID") SYS_OP_MAP_NONNULL("SOURCE") SYS_OP_MAP_NONNULL("SUBINVENTORY_CODE") SYS_OP_MAP_NONNULL("INV_CATEGORY_ID") SYS_OP_MAP_NONNULL("CYCLE_COUNT_HEADER_ID") SYS_OP_MAP_NONNULL("CYCLE_COUNT_CLASS_ID") SYS_OP_MAP_NONNULL("ITEM_ORG_ID") SYS_OP_MAP_NONNULL("UOM_CODE") SYS_OP_MAP_NONNULL("YEAR_ID") SYS_OP_MAP_NONNULL("QTR_ID") SYS_OP_MAP_NONNULL("MONTH_ID") SYS_OP_MAP_NONNULL("WEEK_ID") SYS_OP_MAP_NONNULL("DAY_ID") SYS_OP_MAP_NONNULL("AGGREGATION_LEVEL_FLAG") SYS_OP_MAP_NONNULL("GRP_ID")
OPI_INV_CCA_SUM_MV_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	TIME_ID AGGREGATION_LEVEL_FLAG ORGANIZATION_ID
OPI_INV_CCA_SUM_MV_N2	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	TIME_ID AGGREGATION_LEVEL_FLAG INV_CATEGORY_ID
OPI_INV_CCA_SUM_MV_N3	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	TIME_ID AGGREGATION_LEVEL_FLAG ITEM_ORG_ID
OPI_INV_CCA_SUM_MV_N4	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	TIME_ID AGGREGATION_LEVEL_FLAG SUBINVENTORY_CODE
OPI_INV_CCA_SUM_MV_N5	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	TIME_ID AGGREGATION_LEVEL_FLAG CYCLE_COUNT_CLASS_ID CYCLE_COUNT_HEADER_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ORGANIZATION_ID	NUMBER		Yes	Inventory Organization Identifier
UOM_CODE	VARCHAR2	(3)		Primary unit of measure
CYCLE_COUNT_HEADER_ID	VARCHAR2	(81)		Cycle Count Identifier
CYCLE_COUNT_CLASS_ID	VARCHAR2	(122)		Cycle Count Class identifier
SUBINVENTORY_CODE	VARCHAR2	(51)		Subinventory Code
INV_CATEGORY_ID	NUMBER			Inventory Category Identifier
ITEM_ORG_ID	VARCHAR2	(81)		Item Organization Identifier
AGGREGATION_LEVEL_FLAG	NUMBER			Aggregation level granularity flag
SOURCE	NUMBER		Yes	Data source. 1 = OPI, 2 = OPM
GRP_ID	NUMBER			Grouping ID column
TIME_ID	NUMBER			Nested Grouping ID Column for Time
PERIOD_TYPE_ID	NUMBER			Period Type ID Column for Time
YEAR_ID	NUMBER			FII Year Identifier
QTR_ID	NUMBER			FII Quarter Identifier
MONTH_ID	NUMBER			FII Month Identifier
WEEK_ID	NUMBER			FII Week Identifier
DAY_ID	NUMBER			FII Day Identifier
NUMBER_OF_TOTAL_ENTRIES	NUMBER			Total number of cycle count entries: Number of hits + Number of misses
COUNT_TOT_ENTRIES	NUMBER			Count Column
NUMBER_OF_HITS	NUMBER			Number of cycle count hits
COUNT_HITS	NUMBER			Count Column
NUMBER_OF_MISSES	NUMBER			Number of cycle count misses
COUNT_MISSES	NUMBER			Count Column
NUMBER_OF_EXACT_MATCHES	NUMBER			Number of cycle count exact matches
COUNT_EXACT_MATCHES	NUMBER			Count Column
NUMBER_OF_ADJUSTMENTS	NUMBER			Number of cycle count adjustments
COUNT_ADJUSTMENTS	NUMBER			Count Column
POSITIVE_ADJUSTMENT_QTY	NUMBER			Positive quantity adjustments in primary unit of measure
COUNT_POS_ADJ_QTY	NUMBER			Count Column
NEGATIVE_ADJUSTMENT_QTY	NUMBER			Negative quantity adjustments in primary unit of measure
COUNT_NEG_ADJ_QTY	NUMBER			Count Column
POSITIVE_ADJUSTMENT_VAL_B	NUMBER			Value of positive adjustments in Functional Currency
COUNT_POS_ADJ_VAL_B	NUMBER			Count Column
POSITIVE_ADJUSTMENT_VAL_G	NUMBER			Value of positive adjustments in Primary Global Currency
COUNT_POS_ADJ_VAL_G	NUMBER			Count Column
NEGATIVE_ADJUSTMENT_VAL_B	NUMBER			Value of negative adjustments in Functional Currency
COUNT_NEG_ADJ_VAL_B	NUMBER			Count Column
NEGATIVE_ADJUSTMENT_VAL_G	NUMBER			Value of negative adjustments in Primary Global Currency
COUNT_NEG_ADJ_VAL_G	NUMBER			Count Column
GROSS_ADJUSTMENT_QTY	NUMBER			Gross quantity adjusted in primary unit of measure
COUNT_GR_ADJ_QTY	NUMBER			Count Column
GROSS_ADJUSTMENT_VAL_B	NUMBER			Gross value of adjustments inFunctional Currency
COUNT_GR_ADJ_VAL_B	NUMBER			Count Column
GROSS_ADJUSTMENT_VAL_G	NUMBER			Gross value of adjustments in Primary Global Currency
COUNT_GR_ADJ_VAL_G	NUMBER			Count Column
NET_ADJUSTMENT_QTY	NUMBER			Net quantity adjusted in primary unit of measure
COUNT_NET_ADJ_QTY	NUMBER			Count Column
NET_ADJUSTMENT_VAL_B	NUMBER			Net value of adjustments in Functional Currency
COUNT_NET_ADJ_VAL_B	NUMBER			Count Column
NET_ADJUSTMENT_VAL_G	NUMBER			Net value of adjustments in Primary Global Currency
COUNT_NET_ADJ_VAL_G	NUMBER			Count Column
SYSTEM_INVENTORY_QTY	NUMBER			System inventory quantity in primary unit of measure
COUNT_SYS_INV_QTY	NUMBER			Count Column
SYSTEM_INVENTORY_VAL_B	NUMBER			Value of system inventory in Functional Currency
COUNT_SYS_INV_VAL_B	NUMBER			Count Column
SYSTEM_INVENTORY_VAL_G	NUMBER			Value of system inventory in Primary Global Currency
COUNT_SYS_INV_VAL_G	NUMBER			Count Column
POSITIVE_ADJUSTMENT_VAL_SG	NUMBER			Value of positive adjustments in Secondary Global Currency
COUNT_POS_ADJ_VAL_SG	NUMBER			Count Column
NEGATIVE_ADJUSTMENT_VAL_SG	NUMBER			Value of negative adjustments in Secondary Global Currency
COUNT_NEG_ADJ_VAL_SG	NUMBER			Count Column
GROSS_ADJUSTMENT_VAL_SG	NUMBER			Gross value of adjustments in Secondary Global Currency
COUNT_GR_ADJ_VAL_SG	NUMBER			Count Column
NET_ADJUSTMENT_VAL_SG	NUMBER			Net value of adjustments in Secondary Global Currency
COUNT_NET_ADJ_VAL_SG	NUMBER			Count Column
SYSTEM_INVENTORY_VAL_SG	NUMBER			Value of system inventory in Secondary Global Currency
COUNT_SYS_INV_VAL_SG	NUMBER			Count Column
COUNT_TOTAL	NUMBER			Row Count

Query Text

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


SELECT ORGANIZATION_ID
,      UOM_CODE
,      CYCLE_COUNT_HEADER_ID
,      CYCLE_COUNT_CLASS_ID
,      SUBINVENTORY_CODE
,      INV_CATEGORY_ID
,      ITEM_ORG_ID
,      AGGREGATION_LEVEL_FLAG
,      SOURCE
,      GRP_ID
,      TIME_ID
,      PERIOD_TYPE_ID
,      YEAR_ID
,      QTR_ID
,      MONTH_ID
,      WEEK_ID
,      DAY_ID
,      NUMBER_OF_TOTAL_ENTRIES
,      COUNT_TOT_ENTRIES
,      NUMBER_OF_HITS
,      COUNT_HITS
,      NUMBER_OF_MISSES
,      COUNT_MISSES
,      NUMBER_OF_EXACT_MATCHES
,      COUNT_EXACT_MATCHES
,      NUMBER_OF_ADJUSTMENTS
,      COUNT_ADJUSTMENTS
,      POSITIVE_ADJUSTMENT_QTY
,      COUNT_POS_ADJ_QTY
,      NEGATIVE_ADJUSTMENT_QTY
,      COUNT_NEG_ADJ_QTY
,      POSITIVE_ADJUSTMENT_VAL_B
,      COUNT_POS_ADJ_VAL_B
,      POSITIVE_ADJUSTMENT_VAL_G
,      COUNT_POS_ADJ_VAL_G
,      NEGATIVE_ADJUSTMENT_VAL_B
,      COUNT_NEG_ADJ_VAL_B
,      NEGATIVE_ADJUSTMENT_VAL_G
,      COUNT_NEG_ADJ_VAL_G
,      GROSS_ADJUSTMENT_QTY
,      COUNT_GR_ADJ_QTY
,      GROSS_ADJUSTMENT_VAL_B
,      COUNT_GR_ADJ_VAL_B
,      GROSS_ADJUSTMENT_VAL_G
,      COUNT_GR_ADJ_VAL_G
,      NET_ADJUSTMENT_QTY
,      COUNT_NET_ADJ_QTY
,      NET_ADJUSTMENT_VAL_B
,      COUNT_NET_ADJ_VAL_B
,      NET_ADJUSTMENT_VAL_G
,      COUNT_NET_ADJ_VAL_G
,      SYSTEM_INVENTORY_QTY
,      COUNT_SYS_INV_QTY
,      SYSTEM_INVENTORY_VAL_B
,      COUNT_SYS_INV_VAL_B
,      SYSTEM_INVENTORY_VAL_G
,      COUNT_SYS_INV_VAL_G
,      POSITIVE_ADJUSTMENT_VAL_SG
,      COUNT_POS_ADJ_VAL_SG
,      NEGATIVE_ADJUSTMENT_VAL_SG
,      COUNT_NEG_ADJ_VAL_SG
,      GROSS_ADJUSTMENT_VAL_SG
,      COUNT_GR_ADJ_VAL_SG
,      NET_ADJUSTMENT_VAL_SG
,      COUNT_NET_ADJ_VAL_SG
,      SYSTEM_INVENTORY_VAL_SG
,      COUNT_SYS_INV_VAL_SG
,      COUNT_TOTAL
FROM APPS.OPI_INV_CCA_SUM_MV;

Dependencies

[top of page]

APPS.OPI_INV_CCA_SUM_MV does not reference any database object

APPS.OPI_INV_CCA_SUM_MV is referenced by following:

APPS: OPI_INV_CCA_SUM_MV