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

MATERIALIZED VIEW: APPS.ENI_DBI_BOM_COMPONENTS_MV2

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

BOM_COMPONENTS_B

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
COMPONENT_SEQUENCE_ID NUMBER
Yes Component Sequence Id of the component in a Bill
COUNT(*) NUMBER

Dummy Column to make MV fast refreshable
Query Text

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


SELECT COMPONENT_SEQUENCE_ID
,      COUNT(*)
FROM APPS.ENI_DBI_BOM_COMPONENTS_MV2;

Dependencies

[top of page]

APPS.ENI_DBI_BOM_COMPONENTS_MV2 references the following:

SchemaAPPS
TableENI_DBI_BOM_COMPONENTS_MV2
SchemaBOM
TableBOM_COMPONENTS_B

APPS.ENI_DBI_BOM_COMPONENTS_MV2 is not referenced by any database object