APPS.MTH_SUSTAIN_ASPECT_PKG dependencies on MTH_EQUIPMENT_SHIFTS_D

Line 736: FROM MTH_EQUIPMENT_SHIFTS_D

732: IS
733: CURSOR c_getShifts(p_entity_type IN VARCHAR2, p_entity_fk_key IN VARCHAR2,
734: p_from_time IN DATE, p_to_time IN DATE) IS
735: SELECT from_date, To_Date, availability_flag
736: FROM MTH_EQUIPMENT_SHIFTS_D
737: WHERE equipment_fk_key = p_entity_fk_key AND
738: UPPER(entity_type) = p_entity_type AND
739: To_Date >= p_from_time AND
740: from_date <= p_to_time

Line 1893: FROM mth_equipment_shifts_d

1889: IS
1890: SELECT l_meter_fk_key, l_entity_fk_key, shift_workday_fk_key,
1891: Greatest(from_date, l_from_time) from_time,
1892: least(l_to_time, To_Date) to_time
1893: FROM mth_equipment_shifts_d
1894: WHERE equipment_fk_key = l_entity_fk_key
1895: AND ( from_date <= l_from_time AND to_date >= l_from_time OR
1896: from_date <= l_to_time AND to_date >= l_to_time OR
1897: from_date >= l_from_time AND from_date <= l_to_time ) AND

Line 1907: FROM mth_equipment_shifts_d

1903: IS
1904: SELECT l_meter_fk_key, l_entity_fk_key, shift_workday_fk_key,
1905: l_from_time from_time,
1906: l_to_time to_time
1907: FROM mth_equipment_shifts_d
1908: WHERE equipment_fk_key = l_entity_fk_key
1909: AND Trunc(availability_date) = Trunc(l_from_time)
1910: AND Nvl(from_date, Trunc(availability_date)) = Nvl(To_Date, Trunc(availability_date));
1911:

Line 1935: FROM mth_equipment_shifts_d

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 (
1934: SELECT DISTINCT shift_workday_fk_key shift_key
1935: FROM mth_equipment_shifts_d
1936: WHERE equipment_fk_key = l_entity_fk_key)
1937: AND Trunc(a.shift_date) = Trunc(l_from_time)
1938: AND Nvl(a.from_date, Trunc(a.shift_date)) = Nvl(a.To_Date, Trunc(a.shift_date));
1939: