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

MATERIALIZED VIEW: APPS.OPI_INV_CCA_SUM_MV

Object Details
Object Name: OPI_INV_CCA_SUM_MV
Object Type: MATERIALIZED VIEW
Owner: APPS
Subobject Name:
Status: VALID
M-View Details
Container: OPI_INV_CCA_SUM_MV
Updatable: N
Rewrite Enabled: N
Rewrite Capability: GENERAL
Refresh Mode: DEMAND
Refresh Method: FAST
Build Mode: DEFERRED
Fast Refreshable: DIRLOAD_DML
MV Log Dependencies:

ENI_OLTP_ITEM_STAR
FII_TIME_DAY
OPI_DBI_INV_CCA_F

[View Source Query]

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 references the following:

SchemaAPPS
TableOPI_INV_CCA_SUM_MV
SchemaENI
TableENI_OLTP_ITEM_STAR
SchemaFII
TableFII_TIME_DAY
SchemaOPI
TableOPI_DBI_INV_CCA_F

APPS.OPI_INV_CCA_SUM_MV is not referenced by any database object