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]

MATERIALIZED VIEW: APPS.OPI_PGM_CAT_MV

Object Details

Object Name:	OPI_PGM_CAT_MV
Object Type:	MATERIALIZED VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

M-View Details

Container:	OPI_PGM_CAT_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_DENORM_HIERARCHIES
MTL_DEFAULT_CATEGORY_SETS
OPI_PGM_SUM_MV
     FII_TIME_DAY
     OPI_PGM_GRP_MV
          OPI_PGM_CBN_MV
               ENI_OLTP_ITEM_STAR
               FII_TIME_DAY
               ISC_DBI_CFM_005_MV
                    ENI_OLTP_ITEM_STAR
                    FII_TIME_DAY
                    ISC_BOOK_SUM2_F
               OPI_DBI_COGS_F

[View Source Query]

Columns

Name	Datatype	Comments
ORGANIZATION_ID	NUMBER	Inventory Organization Identifier
ITEM_CATEGORY_ID	NUMBER	Inventory Category Identifier
GROUPING_ID	NUMBER	Grouping ID Column
TIME_ID	NUMBER	Nested Grouping ID Column for Time
PERIOD_TYPE_ID	NUMBER	Period Type Identifier
FULFILLED_VAL_G	NUMBER	Fullfilled Value in Primary Global Currency
FULFILLED_VAL_G_CNT	NUMBER	Count Column
FULFILLED_VAL_B	NUMBER	Fullfilled Value in Functional Currency
FULFILLED_VAL_B_CNT	NUMBER	Count Column
COGS_VAL_G	NUMBER	Cost of Goods Sold Value in Primary Global Currency
COGS_VAL_G_CNT	NUMBER	Count Column
COGS_VAL_B	NUMBER	Cost of Goods Sold Value in Functional Currency
COGS_VAL_B_CNT	NUMBER	Count Column
FULFILLED_VAL_SG	NUMBER	Fullfilled Value in Secondary Global Currency
FULFILLED_VAL_SG_CNT	NUMBER	Count Column
COGS_VAL_SG	NUMBER	Cost of Goods Sold Value in Secondary Global Currency
COGS_VAL_SG_CNT	NUMBER	Count Column
CNT	NUMBER	Row Count

Query Text

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


SELECT ORGANIZATION_ID
,      ITEM_CATEGORY_ID
,      GROUPING_ID
,      TIME_ID
,      PERIOD_TYPE_ID
,      FULFILLED_VAL_G
,      FULFILLED_VAL_G_CNT
,      FULFILLED_VAL_B
,      FULFILLED_VAL_B_CNT
,      COGS_VAL_G
,      COGS_VAL_G_CNT
,      COGS_VAL_B
,      COGS_VAL_B_CNT
,      FULFILLED_VAL_SG
,      FULFILLED_VAL_SG_CNT
,      COGS_VAL_SG
,      COGS_VAL_SG_CNT
,      CNT
FROM APPS.OPI_PGM_CAT_MV;

Dependencies

[top of page]

APPS.OPI_PGM_CAT_MV references the following:

APPS: OPI_PGM_CAT_MV; OPI_PGM_SUM_MV; OPI_PGM_SUM_MV
ENI: ENI_DENORM_HIERARCHIES
INV: MTL_DEFAULT_CATEGORY_SETS

APPS.OPI_PGM_CAT_MV is not referenced by any database object