eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

MATERIALIZED VIEW: APPS.ISC_DBI_PM_0002_MV

Object Details

Object Name:	ISC_DBI_PM_0002_MV
Object Type:	MATERIALIZED VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

M-View Details

Container:	ISC_DBI_PM_0002_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_RES_SUM_SNAPSHOTS

[View Source Query]

Columns

Name	Datatype	Length	Comments
SNAPSHOT_ID	NUMBER		Plan Snapshot Identifier
ORGANIZATION_ID	NUMBER		Inventory Organization Identifier
RESOURCE_ID	VARCHAR2	(122)	Manufacturing Resource Identifier
DEPARTMENT_ID	VARCHAR2	(42)	Manufacturing Department Identifier
RESOURCE_GROUP_ID	VARCHAR2	(32)	Manufacturing Resource Group Identifier
GRP_ID	NUMBER		Grouping ID Column
RES_GP_FLAG	NUMBER		Grouping ID Column for Resource
START_DATE	DATE		Nested Grouping ID Column for Time
PERIOD_TYPE_ID	NUMBER		Nested Grouping ID Column for Time
REQUIRED_HOURS	NUMBER		Resource Required Hours
REQUIRED_HOURS_CNT	NUMBER		Count Column
AVAILABLE_HOURS	NUMBER		Resource Available Hours
AVAILABLE_HOURS_CNT	NUMBER		Count Column
CNT	NUMBER		Row Count

Query Text

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


SELECT SNAPSHOT_ID
,      ORGANIZATION_ID
,      RESOURCE_ID
,      DEPARTMENT_ID
,      RESOURCE_GROUP_ID
,      GRP_ID
,      RES_GP_FLAG
,      START_DATE
,      PERIOD_TYPE_ID
,      REQUIRED_HOURS
,      REQUIRED_HOURS_CNT
,      AVAILABLE_HOURS
,      AVAILABLE_HOURS_CNT
,      CNT
FROM APPS.ISC_DBI_PM_0002_MV;

Dependencies

[top of page]

APPS.ISC_DBI_PM_0002_MV references the following:

APPS: ENI_RES_5_MV; ENI_RES_5_MV; ISC_DBI_PM_0002_MV
ISC: ISC_DBI_RES_SUM_SNAPSHOTS

APPS.ISC_DBI_PM_0002_MV is not referenced by any database object