APPS.WIP_INFRESSCHED_GRP dependencies on MTL_PARAMETERS

Line 917: mtl_parameters mp,

913: select brs.shift_num,
914: bsd.shift_date + bst.from_time/86400,
915: bsd.shift_date + bst.to_time/86400
916: from bom_resource_shifts brs,
917: mtl_parameters mp,
918: bom_shift_dates bsd,
919: bom_shift_times bst,
920: bom_department_resources bdr
921: where bdr.department_id = v_deptID

Line 944: from mtl_parameters mp,

940: v_endDate DATE) is
941: select -1 shiftNum,
942: bcd.calendar_date + wl.start_time/86400,
943: bcd.calendar_date + wl.stop_time/86400
944: from mtl_parameters mp,
945: bom_calendar_dates bcd,
946: wip_lines wl
947: where mp.organization_id = v_orgID
948: and mp.calendar_code = bcd.calendar_code

Line 961: from mtl_parameters mp,

957: v_endDate DATE) is
958: select -1,
959: bcd.calendar_date,
960: bcd.calendar_date + 1
961: from mtl_parameters mp,
962: bom_calendar_dates bcd
963: where mp.organization_id = v_orgID
964: and mp.calendar_code = bcd.calendar_code
965: and mp.calendar_exception_set_id = bcd.exception_set_id

Line 1020: mtl_parameters mp,

1016: into l_dummy
1017: from dual
1018: where exists (select 1
1019: from bom_resource_shifts brs,
1020: mtl_parameters mp,
1021: bom_shift_dates bsd,
1022: bom_shift_times bst,
1023: bom_department_resources bdr
1024: where bdr.department_id = x_resTbls.deptID(p_idx)

Line 1522: from bom_calendars bc, mtl_parameters mp

1518: end if;
1519: --get the maximum date
1520: select bc.calendar_end_date
1521: into l_maxDate
1522: from bom_calendars bc, mtl_parameters mp
1523: where mp.organization_id = p_orgID
1524: and mp.calendar_code = bc.calendar_code;
1525:
1526: while(getNextResIdx(p_range, p_schedFlag, g_forward, x_resTbls, i)) loop

Line 1699: mtl_parameters mp,

1695: select brs.shift_num shiftNum,
1696: bsd.shift_date + bst.from_time/86400,
1697: bsd.shift_date + bst.to_time/86400
1698: from bom_resource_shifts brs,
1699: mtl_parameters mp,
1700: bom_shift_dates bsd,
1701: bom_shift_times bst,
1702: bom_department_resources bdr
1703: where bdr.department_id = v_deptID

Line 1723: from mtl_parameters mp,

1719: v_endDate DATE) is
1720: select -1,
1721: bcd.calendar_date,
1722: bcd.calendar_date + 1
1723: from mtl_parameters mp,
1724: bom_calendar_dates bcd
1725: where mp.organization_id = v_orgID
1726: and mp.calendar_code = bcd.calendar_code
1727: and mp.calendar_exception_set_id = bcd.exception_set_id

Line 1742: from mtl_parameters mp,

1738: v_endDate DATE) is
1739: select -1 shiftNum,
1740: bcd.calendar_date + wl.start_time/86400,
1741: bcd.calendar_date + wl.stop_time/86400
1742: from mtl_parameters mp,
1743: bom_calendar_dates bcd,
1744: wip_lines wl
1745: where mp.organization_id = v_orgID
1746: and mp.calendar_code = bcd.calendar_code

Line 1804: mtl_parameters mp,

1800: into l_dummy
1801: from dual
1802: where exists (select 1
1803: from bom_resource_shifts brs,
1804: mtl_parameters mp,
1805: bom_shift_dates bsd,
1806: bom_shift_times bst,
1807: bom_department_resources bdr
1808: where bdr.department_id = x_resTbls.deptID(p_idx)

Line 2181: from bom_calendars bc, mtl_parameters mp

2177: --get the maximum date
2178:
2179: select bc.calendar_start_date
2180: into l_minDate
2181: from bom_calendars bc, mtl_parameters mp
2182: where mp.organization_id = p_orgID
2183: and mp.calendar_code = bc.calendar_code;
2184:
2185: while(getNextResIdx(p_range, p_schedFlag, g_backward, x_resTbls, i)) loop