[Home] [Help] [Dependency Information]
Object Name: | ENI_RES_2_MV |
---|---|
Object Type: | MATERIALIZED VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Container: | ENI_RES_2_MV |
---|---|
Updatable: | N |
Rewrite Enabled: | N |
Rewrite Capability: | GENERAL |
Refresh Mode: | DEMAND |
Refresh Method: | FAST |
Build Mode: | DEFERRED |
Fast Refreshable: | DIRLOAD_DML |
ENI_RES_1_MV
BOM_DEPARTMENTS
BOM_DEPARTMENT_RESOURCES
BOM_RESOURCES
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RESOURCE_ID | NUMBER | The number of departments this resource is assigned to | ||
NUMBER_RESOURCE | NUMBER | Manufacturing Resource Unique Identifier |
Cut, paste (and edit) the following text to query this object:
SELECT RESOURCE_ID
, NUMBER_RESOURCE
FROM APPS.ENI_RES_2_MV;
|
|
|