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

MATERIALIZED VIEW: APPS.ISC_DBI_CFM_015_MV

Object Details
Object Name: ISC_DBI_CFM_015_MV
Object Type: MATERIALIZED VIEW
Owner: APPS
Subobject Name:
Status: VALID
M-View Details
Container: ISC_DBI_CFM_015_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
ISC_DBI_CFM_002_MV
     ENI_OLTP_ITEM_STAR
     FII_TIME_DAY
     ISC_BOOK_SUM2_F
MTL_DEFAULT_CATEGORY_SETS

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
INV_ORG_ID NUMBER

Inventory Organization Identifier
PARENT_ID NUMBER

Product Category Identifier
TOP_NODE_FLAG VARCHAR2 (1)
Product Category Top Node Flag
GRP_ID NUMBER

Grouping ID Column
TIME_ID NUMBER

Nested Grouping ID Column for Time
PERIOD_TYPE_ID NUMBER

Nested Grouping ID Column for Time
FULFILLED_AMT_G NUMBER

Fulfilled amount in Global currency
FULFILLED_AMT_G_CNT NUMBER

Count Column
FULFILLED_AMT_G1 NUMBER

Fulfilled amount in Secondary Global currency
FULFILLED_AMT_G1_CNT NUMBER

Count Column
FULFILLED_AMT_F NUMBER

Fulfilled amount in Functional currency
FULFILLED_AMT_F_CNT NUMBER

Count Column
FULFILLED_AMT2_G NUMBER

Fulfilled amount (for backlog calculation) in Global currency
FULFILLED_AMT2_G_CNT NUMBER

Count Column
FULFILLED_AMT2_G1 NUMBER

Fulfilled amount (for backlog calculation) in Secondary Global currency
FULFILLED_AMT2_G1_CNT NUMBER

Count Column
FULFILLED_AMT2_F NUMBER

Fulfilled amount (for backlog calculation) in Functional currency
FULFILLED_AMT2_F_CNT NUMBER

Count Column
BOOKED_AMT_G NUMBER

Booked amount in Global currency
BOOKED_AMT_G_CNT NUMBER

Count Column
BOOKED_AMT_G1 NUMBER

Booked amount in Secondary Global currency
BOOKED_AMT_G1_CNT NUMBER

Count Column
BOOKED_AMT_F NUMBER

Booked amount in Functional currency
BOOKED_AMT_F_CNT NUMBER

Count Column
BOOKED_QTY NUMBER

Booked Quantity
BOOKED_QTY_CNT NUMBER

Count Column
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
FULFILLED_QTY NUMBER

Fulfilled Quantity
FULFILLED_QTY_CNT NUMBER

Count Column
RETURNED_QTY NUMBER

Returned Quantity
RETURNED_QTY_CNT NUMBER

Count Column
BOOK_TO_FULFILL_DAYS NUMBER

Count of Days between booked date and fulfilled date
BOOK_TO_FULFILL_CNT NUMBER

Count Column
RETURN_FLAG NUMBER

Grouping ID Column for Return Order Lines
LINES_CNT NUMBER

Count of Fulfilled Order Lines
LINES_CNT_C NUMBER

Count Column
CNT NUMBER

Row Count
Query Text

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


SELECT INV_ORG_ID
,      PARENT_ID
,      TOP_NODE_FLAG
,      GRP_ID
,      TIME_ID
,      PERIOD_TYPE_ID
,      FULFILLED_AMT_G
,      FULFILLED_AMT_G_CNT
,      FULFILLED_AMT_G1
,      FULFILLED_AMT_G1_CNT
,      FULFILLED_AMT_F
,      FULFILLED_AMT_F_CNT
,      FULFILLED_AMT2_G
,      FULFILLED_AMT2_G_CNT
,      FULFILLED_AMT2_G1
,      FULFILLED_AMT2_G1_CNT
,      FULFILLED_AMT2_F
,      FULFILLED_AMT2_F_CNT
,      BOOKED_AMT_G
,      BOOKED_AMT_G_CNT
,      BOOKED_AMT_G1
,      BOOKED_AMT_G1_CNT
,      BOOKED_AMT_F
,      BOOKED_AMT_F_CNT
,      BOOKED_QTY
,      BOOKED_QTY_CNT
,      RETURNED_AMT_G
,      RETURNED_AMT_G_CNT
,      RETURNED_AMT_G1
,      RETURNED_AMT_G1_CNT
,      RETURNED_AMT_F
,      RETURNED_AMT_F_CNT
,      FULFILLED_QTY
,      FULFILLED_QTY_CNT
,      RETURNED_QTY
,      RETURNED_QTY_CNT
,      BOOK_TO_FULFILL_DAYS
,      BOOK_TO_FULFILL_CNT
,      RETURN_FLAG
,      LINES_CNT
,      LINES_CNT_C
,      CNT
FROM APPS.ISC_DBI_CFM_015_MV;

Dependencies

[top of page]

APPS.ISC_DBI_CFM_015_MV references the following:

SchemaAPPS
TableISC_DBI_CFM_002_MV
Materialized ViewISC_DBI_CFM_002_MV
TableISC_DBI_CFM_015_MV
SchemaENI
TableENI_DENORM_HIERARCHIES
SchemaINV
TableMTL_DEFAULT_CATEGORY_SETS

APPS.ISC_DBI_CFM_015_MV is not referenced by any database object