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

MATERIALIZED VIEW: APPS.ENI_RES_1_MV

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

BOM_DEPARTMENTS
BOM_DEPARTMENT_RESOURCES
BOM_RESOURCES

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
MARKER NUMBER

This indicates where the current record is coming from in the Union All
RESDEPT_ROWID ROWID (10)
Rowid of the current row in the BOM_DEPARTMENT_RESOURCES table
RES_ROWID ROWID (10)
Rowid of the current row in the BOM_RESOURCES table
DEPT_ROWID ROWID (10)
Rowid of the current row in the BOM_DEPARTMENTS table
RESOURCE_ID NUMBER

Manufacturing Resource Unique Identifier
RESOURCE_CODE VARCHAR2 (10)
Manufacturing Resource Code
BOM_RESOURCE_TYPE NUMBER

BOM Resource Type
ORGANIZATION_ID NUMBER

Manufacturing Organization Identifier
UNIT_OF_MEASURE VARCHAR2 (3)
Unit Of Measure
DEPARTMENT_ID NUMBER

Manufacturing Department Identifier
DEPARTMENT_CODE VARCHAR2 (10)
Manufacturing Department Code
RESOURCE_GROUP VARCHAR2 (30)
Manufacturing Resource Group Identifier
DISABLE_DATE DATE

Disable Date
Query Text

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


SELECT MARKER
,      RESDEPT_ROWID
,      RES_ROWID
,      DEPT_ROWID
,      RESOURCE_ID
,      RESOURCE_CODE
,      BOM_RESOURCE_TYPE
,      ORGANIZATION_ID
,      UNIT_OF_MEASURE
,      DEPARTMENT_ID
,      DEPARTMENT_CODE
,      RESOURCE_GROUP
,      DISABLE_DATE
FROM APPS.ENI_RES_1_MV;

Dependencies

[top of page]

APPS.ENI_RES_1_MV references the following:

SchemaAPPS
TableENI_RES_1_MV
SchemaBOM
TableBOM_DEPARTMENTS
TableBOM_DEPARTMENT_RESOURCES
TableBOM_RESOURCES
APPS.ENI_RES_1_MV is referenced by following:

SchemaAPPS
Materialized ViewENI_RES_2_MV
Materialized ViewENI_RES_3_MV