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

MATERIALIZED VIEW: APPS.ISC_DBI_CFM_010_MV

Object Details
Object Name: ISC_DBI_CFM_010_MV
Object Type: MATERIALIZED VIEW
Owner: APPS
Subobject Name:
Status: VALID
M-View Details
Container: ISC_DBI_CFM_010_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
ISC_BOOK_SUM2_F
OKI_TIME_ENT_YEAR_MV
     FII_TIME_DAY

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
INV_ORG_ID NUMBER

Inventory Organization Identifier
ITEM_ID VARCHAR2 (25)
Item Organization Identifier
ITEM_CATEGORY_ID NUMBER

Product Category Identifier
CUSTOMER_ID NUMBER

Customer Identifier
UOM VARCHAR2 (30)
Unit Of Measure Code
TIME_SNAPSHOT_DATE_ID DATE

Date on which the snapshot was taken
ITEM_CAT_FLAG NUMBER

Grouping ID Column for Item Dimension
CUSTOMER_FLAG NUMBER

Grouping ID Column for Customer Dimension
GRP_ID NUMBER

Grouping ID Column
BKLG_AMT_G NUMBER

Backlogged amount in Global currency
BKLG_AMT_G_CNT NUMBER

Count Column
BKLG_AMT_F NUMBER

Backlogged amount in Functional currency
BKLG_AMT_F_CNT NUMBER

Count Column
BKLOG_QTY NUMBER

Backlogged Quantity
BKLOG_QTY_CNT NUMBER

Count Column
BKLG_AMT_G1 NUMBER

Backlogged amount in Secondary Global currency
BKLG_AMT_G1_CNT NUMBER

Count Column
CNT NUMBER

Row Count
Query Text

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


SELECT INV_ORG_ID
,      ITEM_ID
,      ITEM_CATEGORY_ID
,      CUSTOMER_ID
,      UOM
,      TIME_SNAPSHOT_DATE_ID
,      ITEM_CAT_FLAG
,      CUSTOMER_FLAG
,      GRP_ID
,      BKLG_AMT_G
,      BKLG_AMT_G_CNT
,      BKLG_AMT_F
,      BKLG_AMT_F_CNT
,      BKLOG_QTY
,      BKLOG_QTY_CNT
,      BKLG_AMT_G1
,      BKLG_AMT_G1_CNT
,      CNT
FROM APPS.ISC_DBI_CFM_010_MV;

Dependencies

[top of page]

APPS.ISC_DBI_CFM_010_MV references the following:

SchemaAPPS
TableISC_DBI_CFM_010_MV
TableOKI_TIME_ENT_YEAR_MV
Materialized ViewOKI_TIME_ENT_YEAR_MV
SchemaENI
TableENI_OLTP_ITEM_STAR
SchemaISC
TableISC_BOOK_SUM2_F
APPS.ISC_DBI_CFM_010_MV is referenced by following:

SchemaAPPS
Materialized ViewISC_DBI_CFM_001_MV