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

MATERIALIZED VIEW: APPS.ISC_DBI_CFM_007_MV

Object Details
Object Name: ISC_DBI_CFM_007_MV
Object Type: MATERIALIZED VIEW
Owner: APPS
Subobject Name:
Status: VALID
M-View Details
Container: ISC_DBI_CFM_007_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
ISC_DBI_CFM_003_MV
     ENI_OLTP_ITEM_STAR
     ISC_BOOK_SUM2_F

[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
MASTER_ITEM_ID VARCHAR2 (25)
Item Identifier
CUSTOMER_ID NUMBER

Customer Identifier
RETURN_REASON VARCHAR2 (80)
Order Item Return Reason Identifier
UOM VARCHAR2 (30)
Unit Of Measure Code
GRP_ID NUMBER

Grouping ID Column
ITEM_CAT_FLAG NUMBER

Grouping ID Column for Item Dimension
CUSTOMER_FLAG NUMBER

Grouping ID Column for Customer Dimension
RETURN_REASON_FLAG NUMBER

Grouping ID for Return Reason Identifier
TIME_ID NUMBER

Nested Grouping ID Column for Time
PERIOD_TYPE_ID NUMBER

Nested Grouping ID Column for Time
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
RETURNED_AMT_G NUMBER

Returned amount in Global currency
RETURNED_AMT_G_CNT NUMBER

Count Column
RETURNED_AMT_G1 NUMBER

Returned amount in Secondary Global currency
RETURNED_AMT_G1_CNT NUMBER

Count Column
RETURNED_AMT_F NUMBER

Returned amount in Functional currency
RETURNED_AMT_F_CNT NUMBER

Count Column
RETURNED_QTY NUMBER

Returned Quantity
RETURNED_QTY_CNT NUMBER

Count Column
LINES_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
,      MASTER_ITEM_ID
,      CUSTOMER_ID
,      RETURN_REASON
,      UOM
,      GRP_ID
,      ITEM_CAT_FLAG
,      CUSTOMER_FLAG
,      RETURN_REASON_FLAG
,      TIME_ID
,      PERIOD_TYPE_ID
,      DAY_ID
,      WEEK_ID
,      ENT_PERIOD_ID
,      ENT_QTR_ID
,      RETURNED_AMT_G
,      RETURNED_AMT_G_CNT
,      RETURNED_AMT_G1
,      RETURNED_AMT_G1_CNT
,      RETURNED_AMT_F
,      RETURNED_AMT_F_CNT
,      RETURNED_QTY
,      RETURNED_QTY_CNT
,      LINES_CNT
FROM APPS.ISC_DBI_CFM_007_MV;

Dependencies

[top of page]

APPS.ISC_DBI_CFM_007_MV references the following:

SchemaAPPS
TableISC_DBI_CFM_003_MV
Materialized ViewISC_DBI_CFM_003_MV
TableISC_DBI_CFM_007_MV
SchemaFII
TableFII_TIME_DAY

APPS.ISC_DBI_CFM_007_MV is not referenced by any database object