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

MATERIALIZED VIEW: APPS.OPI_PGM_SUM_MV

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

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 Length Mandatory Comments
ORGANIZATION_ID NUMBER

Inventory Organization Identifier
CUSTOMER_ID NUMBER

Customer Identifier
ITEM_ORG_ID VARCHAR2 (81)
Item Organization Identifier
TOP_MODEL_ORG_ID NUMBER

Top Model Organization Identifier
ITEM_CATEGORY_ID NUMBER

Inventory Category Identifier
GROUPING_ID NUMBER

Grouping ID Column
CUSTOMER_ITEM_CAT_FLAG NUMBER

Grouping ID Column for Item
TIME_ID NUMBER

Nested Grouping ID Column for Time
PERIOD_TYPE_ID NUMBER

Period Type Identifier
DAY_ID NUMBER

FII Day Identifier
WEEK_ID NUMBER

FII Week Identifier
ENT_PERIOD_ID NUMBER

Enterprise Period Identifier
ENT_QTR_ID NUMBER

Enterprise Quarter 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_QTY NUMBER

Fullfilled Quantity in Primary UOM
FULFILLED_QTY_CNT NUMBER

Count Column
UOM_CODE VARCHAR2 (30)
Primary Unit Of Measure Code
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
,      CUSTOMER_ID
,      ITEM_ORG_ID
,      TOP_MODEL_ORG_ID
,      ITEM_CATEGORY_ID
,      GROUPING_ID
,      CUSTOMER_ITEM_CAT_FLAG
,      TIME_ID
,      PERIOD_TYPE_ID
,      DAY_ID
,      WEEK_ID
,      ENT_PERIOD_ID
,      ENT_QTR_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_QTY
,      FULFILLED_QTY_CNT
,      UOM_CODE
,      FULFILLED_VAL_SG
,      FULFILLED_VAL_SG_CNT
,      COGS_VAL_SG
,      COGS_VAL_SG_CNT
,      CNT
FROM APPS.OPI_PGM_SUM_MV;

Dependencies

[top of page]

APPS.OPI_PGM_SUM_MV references the following:

SchemaAPPS
TableOPI_PGM_GRP_MV
Materialized ViewOPI_PGM_GRP_MV
TableOPI_PGM_SUM_MV
SchemaFII
TableFII_TIME_DAY
APPS.OPI_PGM_SUM_MV is referenced by following:

SchemaAPPS
Materialized ViewOPI_PGM_CAT_MV