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

MATERIALIZED VIEW: APPS.ENI_RES_4_MV

Object Details
Object Name: ENI_RES_4_MV
Object Type: MATERIALIZED VIEW
Owner: APPS
Subobject Name:
Status: VALID
M-View Details
Container: ENI_RES_4_MV
Updatable: N
Rewrite Enabled: Y
Rewrite Capability: GENERAL
Refresh Mode: DEMAND
Refresh Method: FAST
Build Mode: DEFERRED
Fast Refreshable: DIRLOAD_DML
MV Log Dependencies:

CR_RSRC_DTL
CR_RSRC_MST_B

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
MST_ROWID ROWID (10)
Rowid of the current row in the GMP.CR_RSRC_MST_B table
DTL_ROWID ROWID (10)
Rowid of the current row in the GMP.CR_RSRC_DTL table
RESOURCE_ID NUMBER (10) Yes Manufacturing Resource Identifier
RESOURCE_CODE VARCHAR2 (16) Yes Code for the resource
ORGANIZATION_ID NUMBER

Organization Identifier
UNIT_OF_MEASURE VARCHAR2 (3)
Unit Of Measure
DEPARTMENT_ID VARCHAR2 (8)
The Identifier of the Resource Class to which the Resource belongs
DEPARTMENT_CODE VARCHAR2 (10)
The Identifier of the Resource Class to which the Resource belongs
RESOURCE_GROUP VARCHAR2 (16) Yes The Resource Group to which the Resource belongs
DISABLE_DATE DATE

Disable Date for the Resource
Query Text

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


SELECT MST_ROWID
,      DTL_ROWID
,      RESOURCE_ID
,      RESOURCE_CODE
,      ORGANIZATION_ID
,      UNIT_OF_MEASURE
,      DEPARTMENT_ID
,      DEPARTMENT_CODE
,      RESOURCE_GROUP
,      DISABLE_DATE
FROM APPS.ENI_RES_4_MV;

Dependencies

[top of page]

APPS.ENI_RES_4_MV references the following:

SchemaAPPS
TableENI_RES_4_MV
SchemaGMP
TableCR_RSRC_DTL
TableCR_RSRC_MST_B
APPS.ENI_RES_4_MV is referenced by following:

SchemaAPPS
Materialized ViewENI_RES_5_MV