APPS.MTH_SUSTAIN_ASPECT_PKG dependencies on MTH_EQUIPMENTS_D

Line 584: FROM mth_equipments_d

580: v_power_rating NUMBER := 0;
581: BEGIN
582: IF (p_entity_type = 'EQUIPMENT') THEN
583: SELECT power_rating INTO v_power_rating
584: FROM mth_equipments_d
585: WHERE equipment_pk_key = p_entity_fk_key;
586: END IF;
587: IF (v_power_rating IS NULL) THEN
588: v_power_rating := 0;

Line 1929: FROM mth_equipments_d

1925: SELECT plant_fk_key site_id, resource_pk_key entity_pk_key
1926: FROM mth_resources_d
1927: UNION ALL
1928: SELECT plant_fk_key site_id, equipment_pk_key entity_pk_key
1929: FROM mth_equipments_d
1930: ) b
1931: WHERE a.plant_fk_key = b.site_id
1932: AND b.entity_pk_key = l_entity_fk_key
1933: AND a.shift_workday_pk_key NOT IN (