Skip to content

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: TableFND.OPI_INV_CCA_SUM_MV
Subobject Name:
Status: VALID
Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
I_SNAP$_OPI_INV_CCA_SUM_MV FUNCTION-BASED NORMAL UNIQUE TablespaceAPPS_TS_SUMMARY ColumnSYS_OP_MAP_NONNULL("ORGANIZATION_ID")
ColumnSYS_OP_MAP_NONNULL("SOURCE")
ColumnSYS_OP_MAP_NONNULL("SUBINVENTORY_CODE")
ColumnSYS_OP_MAP_NONNULL("INV_CATEGORY_ID")
ColumnSYS_OP_MAP_NONNULL("CYCLE_COUNT_HEADER_ID")
ColumnSYS_OP_MAP_NONNULL("CYCLE_COUNT_CLASS_ID")
ColumnSYS_OP_MAP_NONNULL("ITEM_ORG_ID")
ColumnSYS_OP_MAP_NONNULL("UOM_CODE")
ColumnSYS_OP_MAP_NONNULL("YEAR_ID")
ColumnSYS_OP_MAP_NONNULL("QTR_ID")
ColumnSYS_OP_MAP_NONNULL("MONTH_ID")
ColumnSYS_OP_MAP_NONNULL("WEEK_ID")
ColumnSYS_OP_MAP_NONNULL("DAY_ID")
ColumnSYS_OP_MAP_NONNULL("AGGREGATION_LEVEL_FLAG")
ColumnSYS_OP_MAP_NONNULL("GRP_ID")
OPI_INV_CCA_SUM_MV_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnTIME_ID
ColumnAGGREGATION_LEVEL_FLAG
ColumnORGANIZATION_ID
OPI_INV_CCA_SUM_MV_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnTIME_ID
ColumnAGGREGATION_LEVEL_FLAG
ColumnINV_CATEGORY_ID
OPI_INV_CCA_SUM_MV_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnTIME_ID
ColumnAGGREGATION_LEVEL_FLAG
ColumnITEM_ORG_ID
OPI_INV_CCA_SUM_MV_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnTIME_ID
ColumnAGGREGATION_LEVEL_FLAG
ColumnSUBINVENTORY_CODE
OPI_INV_CCA_SUM_MV_N5 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnTIME_ID
ColumnAGGREGATION_LEVEL_FLAG
ColumnCYCLE_COUNT_CLASS_ID
ColumnCYCLE_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:

SchemaAPPS
Materialized ViewOPI_INV_CCA_SUM_MV