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

MATERIALIZED VIEW: APPS.ENI_DBI_MFG_STEPS_JOIN_MV

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

BOM_OPERATIONAL_ROUTINGS
BOM_OPERATION_SEQUENCES

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
ITEM_ORG_ID VARCHAR2 (81)
Item-Org Id of the routing
ITEM_ID NUMBER
Yes Inventory Item id of the Routing
ORGANIZATION_ID NUMBER
Yes Organization id of the Routing
EFFECTIVITY_DATE DATE
Yes effectivity date
DISABLE_DATE DATE

disable date
MFGSTEPS_COUNT NUMBER

Number of operations of the routing effective between effectivity_date and disable_date
Query Text

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


SELECT ITEM_ORG_ID
,      ITEM_ID
,      ORGANIZATION_ID
,      EFFECTIVITY_DATE
,      DISABLE_DATE
,      MFGSTEPS_COUNT
FROM APPS.ENI_DBI_MFG_STEPS_JOIN_MV;

Dependencies

[top of page]

APPS.ENI_DBI_MFG_STEPS_JOIN_MV references the following:

SchemaAPPS
TableENI_DBI_MFG_STEPS_JOIN_MV
SchemaBOM
TableBOM_OPERATIONAL_ROUTINGS
TableBOM_OPERATION_SEQUENCES

APPS.ENI_DBI_MFG_STEPS_JOIN_MV is not referenced by any database object