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

MATERIALIZED VIEW: APPS.ISC_DBI_PM_0004_MV

Object Details
Object Name: ISC_DBI_PM_0004_MV
Object Type: MATERIALIZED VIEW
Owner: APPS
Subobject Name:
Status: VALID
M-View Details
Container: ISC_DBI_PM_0004_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_RES_5_MV
     ENI_RES_3_MV
          ENI_RES_1_MV
               BOM_DEPARTMENTS
               BOM_DEPARTMENT_RESOURCES
               BOM_RESOURCES
          ENI_RES_2_MV
               ENI_RES_1_MV
                    BOM_DEPARTMENTS
                    BOM_DEPARTMENT_RESOURCES
                    BOM_RESOURCES
     ENI_RES_4_MV
          CR_RSRC_DTL
          CR_RSRC_MST_B
ISC_DBI_SHORTFALL_SNAPSHOTS

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
SNAPSHOT_ID NUMBER

Plan Snapshot Identifier
DMD_ITEM_ID NUMBER

Demand Item Identifier
ORGANIZATION_ID NUMBER

Inventory Organization Identifier
R_RESOURCE_ID VARCHAR2 (122)
Manufacturing Resource Identifier
R_ORG_ID NUMBER

Manufacturing Resource Organization Identifier
R_DEPARTMENT_ID VARCHAR2 (42)
Manufacturing Department Identifier
START_DATE DATE

Nested Grouping ID Column for Time
PERIOD_TYPE_ID NUMBER

Nested Grouping ID Column for Time
GRP_ID NUMBER

Grouping ID Column
REV_SHORTFALL NUMBER

Potential Revenue Shortfall in Functional Currency
REV_SHORTFALL_CNT NUMBER

Count Column
REV_SHORTFALL_G NUMBER

Potential Revenue Shortfall in Global Currency
REV_SHORTFALL_G_CNT NUMBER

Count Column
REV_SHORTFALL_G1 NUMBER

Potential Revenue Shortfall in Secondary Global Currency
REV_SHORTFALL_G1_CNT NUMBER

Count Column
COST_SHORTFALL NUMBER

Potential Cost Shortfall in Functional Currency
COST_SHORTFALL_CNT NUMBER

Count Column
COST_SHORTFALL_G NUMBER

Potential Cost Shortfall in Global Currency
COST_SHORTFALL_G_CNT NUMBER

Count Column
COST_SHORTFALL_G1 NUMBER

Potential Cost Shortfall in Secondary Global Currency
COST_SHORTFALL_G1_CNT NUMBER

Count Column
CNT NUMBER

Row Count
Query Text

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


SELECT SNAPSHOT_ID
,      DMD_ITEM_ID
,      ORGANIZATION_ID
,      R_RESOURCE_ID
,      R_ORG_ID
,      R_DEPARTMENT_ID
,      START_DATE
,      PERIOD_TYPE_ID
,      GRP_ID
,      REV_SHORTFALL
,      REV_SHORTFALL_CNT
,      REV_SHORTFALL_G
,      REV_SHORTFALL_G_CNT
,      REV_SHORTFALL_G1
,      REV_SHORTFALL_G1_CNT
,      COST_SHORTFALL
,      COST_SHORTFALL_CNT
,      COST_SHORTFALL_G
,      COST_SHORTFALL_G_CNT
,      COST_SHORTFALL_G1
,      COST_SHORTFALL_G1_CNT
,      CNT
FROM APPS.ISC_DBI_PM_0004_MV;

Dependencies

[top of page]

APPS.ISC_DBI_PM_0004_MV references the following:

SchemaAPPS
TableENI_RES_5_MV
Materialized ViewENI_RES_5_MV
TableISC_DBI_PM_0004_MV
SchemaISC
TableISC_DBI_SHORTFALL_SNAPSHOTS

APPS.ISC_DBI_PM_0004_MV is not referenced by any database object