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

MATERIALIZED VIEW: APPS.MTH_EQUIP_PROD_SCH_PM_MV

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

MTH_EQUIP_PROD_SCH_DD_MV
     MTH_EQUIPMENT_DENORM_D
     MTH_EQUIP_PROD_SCHEDULE_F
     MTH_ITEM_DENORM_D
     MTH_SHIFT_GREGORIAN_DENORM_MV
          MTH_GREGORIAN_CALENDAR
          MTH_WORKDAY_SHIFTS_D

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
DAY_ID NUMBER

CALENDAR_MONTH_ID NUMBER

PLANNED_QTY_G NUMBER

PLANNED_QTY_G_COUNT NUMBER

PLANNED_QTY_SG NUMBER

PLANNED_QTY_SG_COUNT NUMBER

SHIFT_SCH_PROD NUMBER

SHIFT_SCH_PROD_COUNT NUMBER

HRS_SCH_QTY NUMBER

HRS_SCH_QTY_COUNT NUMBER

TOTAL_COUNT NUMBER

STATUS_CODE NUMBER

PRODUCT_LEVEL9_KEY NUMBER

DEPT_KEY NUMBER

DEPT_EFF_DATE DATE

CUST_LEVEL9_KEY NUMBER

CUST_LEVEL9_EFF_DATE DATE

GROUPING_ID NUMBER

TIME_DIM_KEY NUMBER

TIME_DIM_LEVEL NUMBER

EQUIP_HIER NUMBER

EQUIP_HIER_KEY NUMBER

EQUIP_HIER_EFF_DATE DATE

Query Text

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


SELECT DAY_ID
,      CALENDAR_MONTH_ID
,      PLANNED_QTY_G
,      PLANNED_QTY_G_COUNT
,      PLANNED_QTY_SG
,      PLANNED_QTY_SG_COUNT
,      SHIFT_SCH_PROD
,      SHIFT_SCH_PROD_COUNT
,      HRS_SCH_QTY
,      HRS_SCH_QTY_COUNT
,      TOTAL_COUNT
,      STATUS_CODE
,      PRODUCT_LEVEL9_KEY
,      DEPT_KEY
,      DEPT_EFF_DATE
,      CUST_LEVEL9_KEY
,      CUST_LEVEL9_EFF_DATE
,      GROUPING_ID
,      TIME_DIM_KEY
,      TIME_DIM_LEVEL
,      EQUIP_HIER
,      EQUIP_HIER_KEY
,      EQUIP_HIER_EFF_DATE
FROM APPS.MTH_EQUIP_PROD_SCH_PM_MV;

Dependencies

[top of page]

APPS.MTH_EQUIP_PROD_SCH_PM_MV references the following:

SchemaAPPS
TableMTH_EQUIP_PROD_SCH_DD_MV
Materialized ViewMTH_EQUIP_PROD_SCH_DD_MV
TableMTH_EQUIP_PROD_SCH_PM_MV

APPS.MTH_EQUIP_PROD_SCH_PM_MV is not referenced by any database object