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_UTIL_PKG dependencies on MTH_RESOURCES_D

Line 3053: FROM mth_equipment_shifts_d a,mth_resources_d b WHERE b.resource_pk_key=a.equipment_fk_key AND b.plant_fk_key =l_plant_fk_key

3049: AND equipment_fk_key IN (SELECT DISTINCT(Nvl(a.equipment_fk_key,0))
3050: FROM mth_equipment_shifts_d a,mth_equipments_d b WHERE b.equipment_pk_key=a.equipment_fk_key AND b.plant_fk_key =l_plant_fk_key
3051: UNION ALL
3052: SELECT distinct(Nvl(a.equipment_fk_key,0) )
3053: FROM mth_equipment_shifts_d a,mth_resources_d b WHERE b.resource_pk_key=a.equipment_fk_key AND b.plant_fk_key =l_plant_fk_key
3054:
3055: UNION ALL
3056: SELECT distinct(Nvl(a.equipment_fk_key,0) )
3057: FROM mth_equipment_shifts_d a,mth_plants_d b WHERE b.plant_pk_key=a.equipment_fk_key AND b.plant_pk_key =l_plant_fk_key

Line 3161: FROM mth_resources_d

3157: SELECT plant_pk_key site_id, plant_pk_key entity_pk_key, plant_name entity_name, 'SITE', production_site production_entity
3158: FROM mth_plants_d
3159: UNION ALL
3160: SELECT plant_fk_key site_id, resource_pk_key entity_pk_key, resource_name entity_name, 'RESOURCE', production_resource production_entity
3161: FROM mth_resources_d
3162: UNION ALL
3163: SELECT plant_fk_key site_id, equipment_pk_key entity_pk_key, equipment_name entity_name, 'EQUIPMENT', production_equipment production_entity
3164: FROM mth_equipments_d
3165: )b

Line 3196: FROM mth_resources_d

3192: SELECT plant_pk_key site_id, plant_pk_key entity_pk_key, plant_name entity_name, 'SITE', production_site production_entity
3193: FROM mth_plants_d
3194: UNION ALL
3195: SELECT plant_fk_key site_id, resource_pk_key entity_pk_key, resource_name entity_name, 'RESOURCE', production_resource production_entity
3196: FROM mth_resources_d
3197: UNION ALL
3198: SELECT plant_fk_key site_id, equipment_pk_key entity_pk_key, equipment_name entity_name, 'EQUIPMENT', production_equipment production_entity
3199: FROM mth_equipments_d
3200: )b

Line 3232: FROM mth_resources_d

3228: SELECT plant_pk_key site_id, plant_pk_key entity_pk_key, plant_name entity_name, 'SITE', production_site production_entity
3229: FROM mth_plants_d
3230: UNION ALL
3231: SELECT plant_fk_key site_id, resource_pk_key entity_pk_key, resource_name entity_name, 'RESOURCE', production_resource production_entity
3232: FROM mth_resources_d
3233: UNION ALL
3234: SELECT plant_fk_key site_id, equipment_pk_key entity_pk_key, equipment_name entity_name, 'EQUIPMENT', production_equipment production_entity
3235: FROM mth_equipments_d
3236: )b

Line 3306: FROM mth_resources_d

3302: SELECT plant_pk_key site_id, plant_pk_key entity_pk_key, plant_name entity_name, 'SITE', production_site production_entity
3303: FROM mth_plants_d
3304: UNION ALL
3305: SELECT plant_fk_key site_id, resource_pk_key entity_pk_key, resource_name entity_name, 'RESOURCE', production_resource production_entity
3306: FROM mth_resources_d
3307: UNION ALL
3308: SELECT plant_fk_key site_id, equipment_pk_key entity_pk_key, equipment_name entity_name, 'EQUIPMENT', production_equipment production_entity
3309: FROM mth_equipments_d
3310: )b