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_CBN_MV

Object Details

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

M-View Details

Container:	OPI_PGM_CBN_MV
Updatable:	N
Rewrite Enabled:	N
Rewrite Capability:	TEXTMATCH
Refresh Mode:	DEMAND
Refresh Method:	FAST
Build Mode:	DEFERRED
Fast Refreshable:	DIRLOAD_DML

MV Log Dependencies:


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	Length	Comments
ORGANIZATION_ID	NUMBER		Inventory Organization Identifier
CUSTOMER_ID	NUMBER		Customer Identifier
TOP_MODEL_ITEM_ID	VARCHAR2	(81)	Top Model Item Identifier
TOP_MODEL_ORG_ID	NUMBER		Top Model Organization Identifier
ITEM_CATEGORY_ID	NUMBER		Inventory Category Identifier
TRANSACTION_DATE	DATE		Transaction Date
UOM_CODE	VARCHAR2	(30)	Primary Unit Of Measure Code
FULFILLED_VAL_G	NUMBER		Fullfilled Value in Primary Global Currency
FULFILLED_VAL_B	NUMBER		Fullfilled Value in Functional Currency
FULFILLED_QTY	NUMBER		Fullfilled Quantity in Primary UOM
COGS_VAL_G	NUMBER		Cost of Goods Sold Value in Primary Global Currency
COGS_VAL_B	NUMBER		Cost of Goods Sold Value in Functional Currency
PMARKER	NUMBER		Marker Column
FULFILLED_VAL_G_CNT	NUMBER		Count Column
FULFILLED_VAL_B_CNT	NUMBER		Count Column
FULFILLED_QTY_CNT	NUMBER		Count Column
COGS_VAL_G_CNT	NUMBER		Count Column
COGS_VAL_B_CNT	NUMBER
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
C_TOTAL	NUMBER		Row Count

Query Text

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


SELECT ORGANIZATION_ID
,      CUSTOMER_ID
,      TOP_MODEL_ITEM_ID
,      TOP_MODEL_ORG_ID
,      ITEM_CATEGORY_ID
,      TRANSACTION_DATE
,      UOM_CODE
,      FULFILLED_VAL_G
,      FULFILLED_VAL_B
,      FULFILLED_QTY
,      COGS_VAL_G
,      COGS_VAL_B
,      PMARKER
,      FULFILLED_VAL_G_CNT
,      FULFILLED_VAL_B_CNT
,      FULFILLED_QTY_CNT
,      COGS_VAL_G_CNT
,      COGS_VAL_B_CNT
,      FULFILLED_VAL_SG
,      FULFILLED_VAL_SG_CNT
,      COGS_VAL_SG
,      COGS_VAL_SG_CNT
,      C_TOTAL
FROM APPS.OPI_PGM_CBN_MV;

Dependencies

[top of page]

APPS.OPI_PGM_CBN_MV references the following:

APPS: ISC_DBI_CFM_005_MV; ISC_DBI_CFM_005_MV; OPI_PGM_CBN_MV
ENI: ENI_OLTP_ITEM_STAR
FII: FII_TIME_DAY
OPI: OPI_DBI_COGS_F

APPS.OPI_PGM_CBN_MV is referenced by following:

APPS: OPI_PGM_GRP_MV