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

MATERIALIZED VIEW: APPS.ENI_DBI_PART_COUNT_MV

Object Details
Object Name: ENI_DBI_PART_COUNT_MV
Object Type: MATERIALIZED VIEW
Owner: APPS
Subobject Name:
Status: VALID
M-View Details
Container: ENI_DBI_PART_COUNT_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_DBI_PART_COUNT_F

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
ASSEMBLY_ITEM_ID NUMBER

Item id of the assembly (or Bill)
ORGANIZATION_ID NUMBER

Organization id of the assembly (or Bill)
EFFECTIVITY_DATE DATE

Effectivity date
DISABLE_DATE DATE

Disable date
MAX_BOM_LEVEL NUMBER

Max BOM Level of the components of the assembly that are effective between effectivity_date and disable_date
PART_COUNT NUMBER

Number of components of the assembly effective between effectivity_date and disable_date
Query Text

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


SELECT ASSEMBLY_ITEM_ID
,      ORGANIZATION_ID
,      EFFECTIVITY_DATE
,      DISABLE_DATE
,      MAX_BOM_LEVEL
,      PART_COUNT
FROM APPS.ENI_DBI_PART_COUNT_MV;

Dependencies

[top of page]

APPS.ENI_DBI_PART_COUNT_MV references the following:

SchemaAPPS
TableENI_DBI_PART_COUNT_MV
SchemaENI
TableENI_DBI_PART_COUNT_F

APPS.ENI_DBI_PART_COUNT_MV is not referenced by any database object