APPS.MTH_PROCESS_STATUS_PKG dependencies on MTH_HOUR_D

Line 1409: mth_hour_d mhd

1405: mth_user_dim_entities_mst mue3,
1406: mth_user_dim_entities_mst mue4,
1407: mth_user_dim_entities_mst mue5,
1408: fnd_lookups lkp,
1409: mth_hour_d mhd
1410: WHERE stg.EQUIPMENT_FK = med.EQUIPMENT_PK (+)
1411: AND stg.SHIFT_WORKDAY_FK = wds.SHIFT_WORKDAY_PK (+)
1412: AND mhd.to_time >= stg.from_date
1413: AND mhd.from_time <= stg.to_date

Line 1467: mth_hour_d mhd

1463: mth_user_dim_entities_mst mue3,
1464: mth_user_dim_entities_mst mue4,
1465: mth_user_dim_entities_mst mue5,
1466: fnd_lookups lkp,
1467: mth_hour_d mhd
1468: WHERE stg.EQUIPMENT_FK = med.EQUIPMENT_PK (+)
1469: AND stg.SHIFT_WORKDAY_FK = wds.SHIFT_WORKDAY_PK (+)
1470: AND stg.from_date BETWEEN mhd.from_time AND mhd.to_time
1471: AND stg.To_Date IS NULL

Line 2113: mth_hour_d mhd

2109: mth_user_dim_entities_mst mue3,
2110: mth_user_dim_entities_mst mue4,
2111: mth_user_dim_entities_mst mue5,
2112: fnd_lookups lkp,
2113: mth_hour_d mhd
2114: WHERE stg.EQUIPMENT_FK = med.EQUIPMENT_PK (+)
2115: AND stg.SHIFT_WORKDAY_FK = wds.SHIFT_WORKDAY_PK (+)
2116: AND mhd.to_time >= stg.from_date
2117: AND mhd.from_time <= stg.to_date

Line 2164: mth_hour_d mhd

2160: mth_user_dim_entities_mst mue3,
2161: mth_user_dim_entities_mst mue4,
2162: mth_user_dim_entities_mst mue5,
2163: fnd_lookups lkp,
2164: mth_hour_d mhd
2165: WHERE stg.EQUIPMENT_FK = med.EQUIPMENT_PK (+)
2166: AND stg.SHIFT_WORKDAY_FK = wds.SHIFT_WORKDAY_PK (+)
2167: AND stg.from_date BETWEEN mhd.from_time AND mhd.to_time
2168: AND stg.To_Date IS NULL

Line 3147: mth_hour_d mhd

3143: mth_user_dim_entities_mst mue3,
3144: mth_user_dim_entities_mst mue4,
3145: mth_user_dim_entities_mst mue5,
3146: fnd_lookups lkp,
3147: mth_hour_d mhd
3148: WHERE stg.EQUIPMENT_FK = med.EQUIPMENT_PK (+)
3149: AND stg.SHIFT_WORKDAY_FK = wds.SHIFT_WORKDAY_PK (+)
3150: AND mhd.to_time >= stg.from_date
3151: AND mhd.from_time <= stg.to_date

Line 3204: mth_hour_d mhd

3200: mth_user_dim_entities_mst mue3,
3201: mth_user_dim_entities_mst mue4,
3202: mth_user_dim_entities_mst mue5,
3203: fnd_lookups lkp,
3204: mth_hour_d mhd
3205: WHERE stg.EQUIPMENT_FK = med.EQUIPMENT_PK (+)
3206: AND stg.SHIFT_WORKDAY_FK = wds.SHIFT_WORKDAY_PK (+)
3207: AND stg.from_date BETWEEN mhd.from_time AND mhd.to_time
3208: AND stg.To_Date IS NULL

Line 3435: mth_hour_d msg,

3431: v_ua_val,
3432: Min(med.level9_level_key) resource_fk_key,
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

Line 3513: mth_hour_d msg,

3509: v_ua_val last_update_system_id,
3510: Min(med.level9_level_key) resource_fk_key,
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

Line 3630: FROM mth_hour_d

3626:
3627: /*CURSOR c_fetch_from_date
3628: IS
3629: SELECT Min(from_time)
3630: FROM mth_hour_d
3631: WHERE (SELECT Min(Max(reading_time))
3632: FROM mth_tag_readings
3633: WHERE reading_time < p_recalc_from_date
3634: GROUP BY equipment_fk_key) BETWEEN from_time AND to_time;*/

Line 3639: FROM mth_hour_d

3635:
3636: CURSOR c_fetch_from_date
3637: IS
3638: SELECT Min(from_time)
3639: FROM mth_hour_d
3640: WHERE (SELECT Min(from_date) reading_time
3641: FROM mth_equip_statuses_stg stg,
3642: mth_equipments_d eq
3643: WHERE stg.equipment_fk = eq.equipment_pk

Line 3654: FROM mth_hour_d

3650:
3651: /*CURSOR c_fetch_to_date
3652: IS
3653: SELECT Max(to_time)
3654: FROM mth_hour_d
3655: WHERE (SELECT Max(Min(reading_time))
3656: FROM mth_tag_readings
3657: WHERE reading_time > v_recalc_to_date
3658: GROUP BY equipment_fk_key) BETWEEN from_time AND to_time;*/

Line 3663: FROM mth_hour_d

3659:
3660: CURSOR c_fetch_to_date
3661: IS
3662: SELECT Max(to_time)
3663: FROM mth_hour_d
3664: WHERE (SELECT Max(to_date) reading_time
3665: FROM mth_equip_statuses_stg stg,
3666: mth_equipments_d eq
3667: WHERE stg.equipment_fk = eq.equipment_pk

Line 3730: FROM mth_hour_d

3726: -- for particular hour fk keys that contains the recalculation from and to dates
3727: IF (p_recalc_plant_key IS NULL ) THEN
3728: DELETE MTH_EQUIP_STATUS_SUMMARY
3729: WHERE hour_fk_key IN (SELECT hour_pk_key
3730: FROM mth_hour_d
3731: WHERE from_time >= p_n_recalc_from_date
3732: AND to_time <= p_n_recalc_to_date)
3733: AND equipment_fk_key = nvl(p_recalc_equip_key,equipment_fk_key);
3734: ELSE

Line 3737: FROM mth_hour_d

3733: AND equipment_fk_key = nvl(p_recalc_equip_key,equipment_fk_key);
3734: ELSE
3735: DELETE MTH_EQUIP_STATUS_SUMMARY
3736: WHERE hour_fk_key IN (SELECT hour_pk_key
3737: FROM mth_hour_d
3738: WHERE from_time >= p_n_recalc_from_date
3739: AND to_time <= p_n_recalc_to_date)
3740: AND equipment_fk_key = nvl(p_recalc_equip_key,equipment_fk_key)
3741: AND equipment_fk_key IN (SELECT equipment_pk_key

Line 3784: mth_hour_d msg,

3780: v_ua_val,
3781: Min(med.level9_level_key) resource_fk_key,
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

Line 3794: FROM mth_hour_d

3790: AND Nvl(med.equipment_expiration_date , msg.from_time)
3791: AND med.equipment_fk_key = eqsts.equipment_fk_key
3792: AND eqsts.hour_fk_key = msg.hour_pk_key
3793: AND eqsts.hour_fk_key IN (SELECT hour_pk_key
3794: FROM mth_hour_d
3795: WHERE from_time >= p_n_recalc_from_date
3796: AND to_time <= p_n_recalc_to_date)
3797: AND eqsts.equipment_fk_key = nvl(p_recalc_equip_key,eqsts.equipment_fk_key)
3798: AND eqsts.equipment_fk_key IN (SELECT equipment_pk_key