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

MATERIALIZED VIEW: APPS.OPI_COGS_001_MV

Object Details
Object Name: OPI_COGS_001_MV
Object Type: MATERIALIZED VIEW
Owner: APPS
Subobject Name:
Status: VALID
M-View Details
Container: OPI_COGS_001_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_COGS_F

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER
Yes Inventory Organization Identifier.
ITEM_ORG_ID VARCHAR2 (25)
Item Organization Identifier.
UOM_CODE VARCHAR2 (5)
Primary unit of measure.
INV_CATEGORY_ID NUMBER

Inventory Category Identifier.
AGGREGATION_LEVEL_FLAG NUMBER

Aggregation level granularity flag.
GRP_ID NUMBER

Grouping ID column.
TIME_ID NUMBER

Nested Grouping ID Column for Time.
PERIOD_TYPE_ID NUMBER

Nested Grouping ID Column for Period Type.
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.
COGS_VAL_B NUMBER

Cost of goods sold in functional currency.
CNT_COGS_VAL_B NUMBER

Count Column.
COGS_VAL_G NUMBER

Cost of goods sold in global currency.
CNT_COGS_VAL_G NUMBER

Count Column.
COGS_VAL_SG NUMBER

Cost of goods sold in secondary global currency.
CNT_COGS_VAL_SG NUMBER

Count Column.
CNT_TOTAL NUMBER

Row Count.
Query Text

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


SELECT ORGANIZATION_ID
,      ITEM_ORG_ID
,      UOM_CODE
,      INV_CATEGORY_ID
,      AGGREGATION_LEVEL_FLAG
,      GRP_ID
,      TIME_ID
,      PERIOD_TYPE_ID
,      YEAR_ID
,      QTR_ID
,      MONTH_ID
,      WEEK_ID
,      DAY_ID
,      COGS_VAL_B
,      CNT_COGS_VAL_B
,      COGS_VAL_G
,      CNT_COGS_VAL_G
,      COGS_VAL_SG
,      CNT_COGS_VAL_SG
,      CNT_TOTAL
FROM APPS.OPI_COGS_001_MV;

Dependencies

[top of page]

APPS.OPI_COGS_001_MV references the following:

SchemaAPPS
TableOPI_COGS_001_MV
SchemaENI
TableENI_OLTP_ITEM_STAR
SchemaFII
TableFII_TIME_DAY
SchemaOPI
TableOPI_DBI_COGS_F

APPS.OPI_COGS_001_MV is not referenced by any database object