955: SET stg.err_code = stg.err_code || 'ESD '
956: WHERE NOT EXISTS ( SELECT * FROM
957: ( SELECT mee.equipment_pk, mws.shift_workday_pk
958: FROM mth_equipments_d mee,
959: mth_equipment_shifts_d med,
960: mth_workday_shifts_d mws
961: WHERE mee.equipment_pk_key = med.equipment_fk_key
962: AND med.shift_workday_fk_key = mws.shift_workday_pk_key
963: AND med.entity_type = 'EQUIPMENT') esd
1137: WHERE EXISTS ( SELECT * FROM (
1138: SELECT mds.shift_workday_pk,med.equipment_pk,mes.from_date,mes.To_Date
1139: FROM mth_workday_shifts_d mds,
1140: mth_equip_statuses_stg stg,
1141: mth_equipment_shifts_d mes,
1142: mth_equipments_d med
1143: WHERE stg.shift_workday_fk = mds.shift_workday_pk
1144: AND stg.equipment_fk = med.equipment_pk
1145: AND mds.shift_workday_pk_key = mes.shift_workday_fk_key
1161: WHERE EXISTS ( SELECT * FROM (
1162: SELECT mds.shift_workday_pk,med.equipment_pk,mes.from_date,mes.To_Date
1163: FROM mth_workday_shifts_d mds,
1164: mth_equip_statuses_stg stg,
1165: mth_equipment_shifts_d mes,
1166: mth_equipments_d med
1167: WHERE stg.shift_workday_fk = mds.shift_workday_pk
1168: AND stg.equipment_fk = med.equipment_pk
1169: AND mds.shift_workday_pk_key = mes.shift_workday_fk_key
1695: SET stg.err_code = stg.err_code || 'ESD '
1696: WHERE NOT EXISTS ( SELECT * FROM
1697: ( SELECT mee.equipment_pk, mws.shift_workday_pk
1698: FROM mth_equipments_d mee,
1699: mth_equipment_shifts_d med,
1700: mth_workday_shifts_d mws
1701: WHERE mee.equipment_pk_key = med.equipment_fk_key
1702: AND med.shift_workday_fk_key = mws.shift_workday_pk_key
1703: AND med.entity_type = 'EQUIPMENT') esd
1877: WHERE EXISTS ( SELECT * FROM (
1878: SELECT mds.shift_workday_pk,med.equipment_pk,mes.from_date,mes.To_Date
1879: FROM mth_workday_shifts_d mds,
1880: mth_equip_statuses_stg stg,
1881: mth_equipment_shifts_d mes,
1882: mth_equipments_d med
1883: WHERE stg.shift_workday_fk = mds.shift_workday_pk
1884: AND stg.equipment_fk = med.equipment_pk
1885: AND mds.shift_workday_pk_key = mes.shift_workday_fk_key
1901: WHERE EXISTS ( SELECT * FROM (
1902: SELECT mds.shift_workday_pk,med.equipment_pk,mes.from_date,mes.To_Date
1903: FROM mth_workday_shifts_d mds,
1904: mth_equip_statuses_stg stg,
1905: mth_equipment_shifts_d mes,
1906: mth_equipments_d med
1907: WHERE stg.shift_workday_fk = mds.shift_workday_pk
1908: AND stg.equipment_fk = med.equipment_pk
1909: AND mds.shift_workday_pk_key = mes.shift_workday_fk_key
2695: SET stg.err_code = stg.err_code || 'ESD '
2696: WHERE NOT EXISTS ( SELECT * FROM
2697: ( SELECT mee.equipment_pk, mws.shift_workday_pk
2698: FROM mth_equipments_d mee,
2699: mth_equipment_shifts_d med,
2700: mth_workday_shifts_d mws
2701: WHERE mee.equipment_pk_key = med.equipment_fk_key
2702: AND med.shift_workday_fk_key = mws.shift_workday_pk_key
2703: AND med.entity_type = 'EQUIPMENT') esd
2865: WHERE EXISTS ( SELECT * FROM (
2866: SELECT mds.shift_workday_pk,med.equipment_pk,mes.from_date,mes.To_Date
2867: FROM mth_workday_shifts_d mds,
2868: mth_equip_statuses_stg stg,
2869: mth_equipment_shifts_d mes,
2870: mth_equipments_d med
2871: WHERE stg.shift_workday_fk = mds.shift_workday_pk
2872: AND stg.equipment_fk = med.equipment_pk
2873: AND mds.shift_workday_pk_key = mes.shift_workday_fk_key
2887: WHERE EXISTS ( SELECT * FROM (
2888: SELECT mds.shift_workday_pk,med.equipment_pk,mes.from_date,mes.To_Date
2889: FROM mth_workday_shifts_d mds,
2890: mth_equip_statuses_stg stg,
2891: mth_equipment_shifts_d mes,
2892: mth_equipments_d med
2893: WHERE stg.shift_workday_fk = mds.shift_workday_pk
2894: AND stg.equipment_fk = med.equipment_pk
2895: AND mds.shift_workday_pk_key = mes.shift_workday_fk_key