eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MTH_PROCESS_OUTPUT_PKG dependencies on MTH_HOUR_D

Line 1115: mth_hour_d mhd

1111: mth_user_dim_entities_mst mue3,
1112: mth_user_dim_entities_mst mue4,
1113: mth_user_dim_entities_mst mue5,
1114: fnd_lookups lkp,
1115: mth_hour_d mhd
1116: WHERE stg.EQUIPMENT_FK = med.EQUIPMENT_PK (+)
1117: AND stg.SHIFT_WORKDAY_FK = wds.SHIFT_WORKDAY_PK (+)
1118: AND stg.ITEM_FK = mid.ITEM_PK (+)
1119: AND stg.WORKORDER_FK = mps.WORKORDER_PK (+)

Line 1678: mth_hour_d mhd

1674: mth_user_dim_entities_mst mue3,
1675: mth_user_dim_entities_mst mue4,
1676: mth_user_dim_entities_mst mue5,
1677: fnd_lookups lkp,
1678: mth_hour_d mhd
1679: WHERE stg.EQUIPMENT_FK = med.EQUIPMENT_PK (+)
1680: AND stg.SHIFT_WORKDAY_FK = wds.SHIFT_WORKDAY_PK (+)
1681: AND stg.ITEM_FK = mid.ITEM_PK (+)
1682: AND stg.WORKORDER_FK = mps.WORKORDER_PK (+)

Line 2237: mth_hour_d mhd

2233: mth_user_dim_entities_mst mue3,
2234: mth_user_dim_entities_mst mue4,
2235: mth_user_dim_entities_mst mue5,
2236: fnd_lookups lkp,
2237: mth_hour_d mhd
2238: WHERE stg.EQUIPMENT_FK = med.EQUIPMENT_PK (+)
2239: AND stg.SHIFT_WORKDAY_FK = wds.SHIFT_WORKDAY_PK (+)
2240: AND stg.ITEM_FK = mid.ITEM_PK (+)
2241: AND stg.WORKORDER_FK = mps.WORKORDER_PK (+)

Line 2947: FROM mth_hour_d

2943:
2944: CURSOR c_fetch_from_date
2945: IS
2946: SELECT Min(from_time)
2947: FROM mth_hour_d
2948: WHERE p_recalc_from_date BETWEEN from_time AND to_time;
2949:
2950: CURSOR c_fetch_to_date
2951: IS

Line 2953: FROM mth_hour_d

2949:
2950: CURSOR c_fetch_to_date
2951: IS
2952: SELECT Max(to_time)
2953: FROM mth_hour_d
2954: WHERE v_recalc_to_date BETWEEN from_time AND to_time;
2955:
2956: CURSOR c_fetch_recalc_to_date
2957: IS

Line 3023: FROM mth_hour_d

3019: UPDATE MTH_EQUIP_STATUS_SUMMARY
3020: SET wo_item_count = null,
3021: required_hours = null
3022: WHERE hour_fk_key IN (SELECT hour_pk_key
3023: FROM mth_hour_d
3024: WHERE from_time >= p_n_recalc_from_date
3025: AND to_time <= p_n_recalc_to_date)
3026: AND equipment_fk_key = nvl(p_recalc_equip_key,equipment_fk_key);
3027: ELSE

Line 3032: FROM mth_hour_d

3028: UPDATE MTH_EQUIP_STATUS_SUMMARY
3029: SET wo_item_count = null,
3030: required_hours = null
3031: WHERE hour_fk_key IN (SELECT hour_pk_key
3032: FROM mth_hour_d
3033: WHERE from_time >= p_n_recalc_from_date
3034: AND to_time <= p_n_recalc_to_date)
3035: AND equipment_fk_key = nvl(p_recalc_equip_key,equipment_fk_key)
3036: AND equipment_fk_key IN (SELECT equipment_pk_key

Line 3047: FROM mth_hour_d

3043: IF (p_recalc_plant_key IS NULL ) THEN
3044: DELETE
3045: FROM MTH_EQUIP_OUTPUT_SUMMARY
3046: WHERE hour_fk_key IN (SELECT hour_pk_key
3047: FROM mth_hour_d
3048: WHERE from_time >= p_n_recalc_from_date
3049: AND to_time <= p_n_recalc_to_date)
3050: AND equipment_fk_key = nvl(p_recalc_equip_key,equipment_fk_key);
3051: ELSE

Line 3055: FROM mth_hour_d

3051: ELSE
3052: DELETE
3053: FROM MTH_EQUIP_OUTPUT_SUMMARY
3054: WHERE hour_fk_key IN (SELECT hour_pk_key
3055: FROM mth_hour_d
3056: WHERE from_time >= p_n_recalc_from_date
3057: AND to_time <= p_n_recalc_to_date)
3058: AND equipment_fk_key = nvl(p_recalc_equip_key,equipment_fk_key)
3059: AND equipment_fk_key IN (SELECT equipment_pk_key

Line 3138: FROM mth_hour_d

3134: AND meo.equipment_fk_key = srf.equipment_fk_key(+)
3135: AND meo.item_fk_key = srf.item_fk_key(+)
3136: AND meo.shift_workday_fk_key = srf.shift_workday_fk_key(+)
3137: AND meo.hour_fk_key IN (SELECT hour_pk_key
3138: FROM mth_hour_d
3139: WHERE from_time >= p_n_recalc_from_date
3140: AND to_time <= p_n_recalc_to_date)
3141: AND meo.equipment_fk_key = nvl(p_recalc_equip_key,meo.equipment_fk_key)
3142: AND meo.equipment_fk_key IN (SELECT equipment_pk_key

Line 3185: FROM mth_hour_d

3181: FROM MTH_EQUIP_OUTPUT_SUMMARY meos
3182: WHERE meos.standard_rate_1 is NOT NULL
3183: AND meos.standard_rate_1 <> 0
3184: AND meos.hour_fk_key IN (SELECT hour_pk_key
3185: FROM mth_hour_d
3186: WHERE from_time >= p_n_recalc_from_date
3187: AND to_time <= p_n_recalc_to_date)
3188: AND meos.equipment_fk_key = nvl(p_recalc_equip_key,meos.equipment_fk_key)
3189: AND meos.equipment_fk_key IN (SELECT equipment_pk_key

Line 3219: FROM mth_hour_d

3215: FROM MTH_EQUIP_OUTPUT_SUMMARY meos
3216: WHERE meos.standard_rate_1 is NOT NULL
3217: AND meos.standard_rate_1 <> 0
3218: AND meos.hour_fk_key IN (SELECT hour_pk_key
3219: FROM mth_hour_d
3220: WHERE from_time >= p_n_recalc_from_date
3221: AND to_time <= p_n_recalc_to_date)
3222: AND meos.equipment_fk_key = nvl(p_recalc_equip_key,meos.equipment_fk_key)
3223: AND meos.equipment_fk_key IN (SELECT equipment_pk_key