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_STATUS_PKG dependencies on MTH_EQUIPMENT_DENORM_D

Line 3436: mth_equipment_denorm_d med,

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
3440: AND msg.from_time BETWEEN med.equipment_effective_date

Line 3514: mth_equipment_denorm_d med,

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
3518: AND msg.from_time BETWEEN med.equipment_effective_date

Line 3785: mth_equipment_denorm_d med,

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
3789: AND msg.from_time BETWEEN med.equipment_effective_date