APPS.MTH_PROCESS_STATUS_PKG dependencies on MTH_RESOURCE_COST_MV

Line 88: WHERE mview_name IN ('MTH_RESOURCE_COST_MV')

84: SELECT mview_name
85: BULK COLLECT
86: INTO v_compile_state
87: FROM dba_mviews
88: WHERE mview_name IN ('MTH_RESOURCE_COST_MV')
89: AND owner = sys_context('USERENV','CURRENT_SCHEMA')
90: AND compile_state <> 'VALID' ;
91:
92: IF v_compile_state.Count > 0

Line 3437: mth_resource_cost_mv mrc

3433: Min(mrc.cost) resource_cost
3434: FROM mth_equip_statuses eqsts,
3435: mth_hour_d msg,
3436: mth_equipment_denorm_d med,
3437: mth_resource_cost_mv mrc
3438: WHERE med.equipment_hierarchy_key = -2
3439: AND med.equipment_fk_key IS NOT NULL
3440: AND msg.from_time BETWEEN med.equipment_effective_date
3441: AND Nvl(med.equipment_expiration_date , msg.from_time)

Line 3515: mth_resource_cost_mv mrc

3511: Min(mrc.cost) resource_cost
3512: FROM mth_equip_statuses eqsts,
3513: mth_hour_d msg,
3514: mth_equipment_denorm_d med,
3515: mth_resource_cost_mv mrc
3516: WHERE med.equipment_hierarchy_key = -2
3517: AND med.equipment_fk_key IS NOT NULL
3518: AND msg.from_time BETWEEN med.equipment_effective_date
3519: AND Nvl(med.equipment_expiration_date , msg.from_time)

Line 3786: mth_resource_cost_mv mrc

3782: Min(mrc.cost) resource_cost
3783: FROM mth_equip_statuses eqsts,
3784: mth_hour_d msg,
3785: mth_equipment_denorm_d med,
3786: mth_resource_cost_mv mrc
3787: WHERE med.equipment_hierarchy_key = -2
3788: AND med.equipment_fk_key IS NOT NULL
3789: AND msg.from_time BETWEEN med.equipment_effective_date
3790: AND Nvl(med.equipment_expiration_date , msg.from_time)