APPS.MTH_PROCESS_STATUS_PKG dependencies on MTH_EQUIPMENT_REASON_SETUP

Line 1255: MTH_EQUIPMENT_REASON_SETUP mer,

1251: SET stg.err_code = stg.err_code ||'WRC '
1252: WHERE NOT EXISTS ( SELECT *
1253: FROM (SELECT stg.*
1254: FROM mth_equip_statuses_stg stg,
1255: MTH_EQUIPMENT_REASON_SETUP mer,
1256: mth_equipments_d med
1257: WHERE stg.equipment_fk = med.equipment_pk
1258: AND med.equipment_pk_key = mer.equipment_fk_key
1259: AND stg.downtime_reason_code = mer.reason_code

Line 1995: MTH_EQUIPMENT_REASON_SETUP mer,

1991: SET stg.err_code = stg.err_code ||'WRC '
1992: WHERE NOT EXISTS ( SELECT *
1993: FROM (SELECT stg.*
1994: FROM mth_equip_statuses_stg stg,
1995: MTH_EQUIPMENT_REASON_SETUP mer,
1996: mth_equipments_d med
1997: WHERE stg.equipment_fk = med.equipment_pk
1998: AND med.equipment_pk_key = mer.equipment_fk_key
1999: AND stg.downtime_reason_code = mer.reason_code

Line 2975: MTH_EQUIPMENT_REASON_SETUP mer,

2971: SET stg.err_code = stg.err_code ||'WRC '
2972: WHERE NOT EXISTS ( SELECT *
2973: FROM (SELECT stg.*
2974: FROM mth_equip_statuses_stg stg,
2975: MTH_EQUIPMENT_REASON_SETUP mer,
2976: mth_equipments_d med
2977: WHERE stg.equipment_fk = med.equipment_pk
2978: AND med.equipment_pk_key = mer.equipment_fk_key
2979: AND stg.downtime_reason_code = mer.reason_code