APPS.WIP_INFRESSCHED_GRP dependencies on MTL_PARAMETERS

Line 1136: mtl_parameters mp,

1132: bsd.shift_date + bst.to_time/86400
1133: END
1134: --bsd.shift_date + bst.to_time/86400
1135: from bom_resource_shifts brs,
1136: mtl_parameters mp,
1137: bom_shift_dates bsd,
1138: bom_shift_times bst,
1139: bom_department_resources bdr
1140: where bdr.department_id = v_deptID

Line 1163: from mtl_parameters mp,

1159: v_endDate DATE) is
1160: select -1 shiftNum,
1161: bcd.calendar_date + wl.start_time/86400,
1162: bcd.calendar_date + wl.stop_time/86400
1163: from mtl_parameters mp,
1164: bom_calendar_dates bcd,
1165: wip_lines wl
1166: where mp.organization_id = v_orgID
1167: and mp.calendar_code = bcd.calendar_code

Line 1180: from mtl_parameters mp,

1176: v_endDate DATE) is
1177: select -1,
1178: bcd.calendar_date,
1179: bcd.calendar_date + 1
1180: from mtl_parameters mp,
1181: bom_calendar_dates bcd
1182: where mp.organization_id = v_orgID
1183: and mp.calendar_code = bcd.calendar_code
1184: and mp.calendar_exception_set_id = bcd.exception_set_id

Line 2074: from bom_calendars bc, mtl_parameters mp

2070: end if;
2071: --get the maximum date
2072: select bc.calendar_end_date
2073: into l_maxDate
2074: from bom_calendars bc, mtl_parameters mp
2075: where mp.organization_id = p_orgID
2076: and mp.calendar_code = bc.calendar_code;
2077:
2078: while(getNextResIdx(p_range, p_schedFlag, g_forward, x_resTbls, i)) loop

Line 2259: mtl_parameters mp,

2255: bsd.shift_date + bst.to_time/86400
2256: END
2257: --bsd.shift_date + bst.to_time/86400
2258: from bom_resource_shifts brs,
2259: mtl_parameters mp,
2260: bom_shift_dates bsd,
2261: bom_shift_times bst,
2262: bom_department_resources bdr
2263: where bdr.department_id = v_deptID

Line 2283: from mtl_parameters mp,

2279: v_endDate DATE) is
2280: select -1,
2281: bcd.calendar_date,
2282: bcd.calendar_date + 1
2283: from mtl_parameters mp,
2284: bom_calendar_dates bcd
2285: where mp.organization_id = v_orgID
2286: and mp.calendar_code = bcd.calendar_code
2287: and mp.calendar_exception_set_id = bcd.exception_set_id

Line 2302: from mtl_parameters mp,

2298: v_endDate DATE) is
2299: select -1 shiftNum,
2300: bcd.calendar_date + wl.start_time/86400,
2301: bcd.calendar_date + wl.stop_time/86400
2302: from mtl_parameters mp,
2303: bom_calendar_dates bcd,
2304: wip_lines wl
2305: where mp.organization_id = v_orgID
2306: and mp.calendar_code = bcd.calendar_code

Line 2752: from bom_calendars bc, mtl_parameters mp

2748: --get the maximum date
2749:
2750: select bc.calendar_start_date
2751: into l_minDate
2752: from bom_calendars bc, mtl_parameters mp
2753: where mp.organization_id = p_orgID
2754: and mp.calendar_code = bc.calendar_code;
2755:
2756: while(getNextResIdx(p_range, p_schedFlag, g_backward, x_resTbls, i)) loop