APPS.WIP_DEFAULT_REPSCHEDULE dependencies on WIP_LINES

Line 110: FROM wip_lines

106: AND g_RepSchedule_rec.organization_id IS NOT NULL
107: THEN
108: SELECT minimum_rate, maximum_rate, fixed_throughput
109: INTO l_min_rate, l_max_rate, l_fixed_thruput
110: FROM wip_lines
111: WHERE line_id = g_RepSchedule_rec.line_id
112: AND organization_id = g_RepSchedule_rec.organization_id;
113:
114: RETURN l_max_rate;

Line 205: FROM wip_lines

201: -- If the line is routing based and the assembly does not have a routing, default the first unit completion date to be the same as the first unit start DATE.
202:
203: IF g_RepSchedule_rec.line_id IS NOT NULL THEN
204: SELECT line_schedule_type INTO l_line_sch_type
205: FROM wip_lines
206: WHERE line_id = g_RepSchedule_rec.line_id;
207:
208:
209: IF l_line_sch_type = 1 THEN --DO not default for Fixed LT lines

Line 256: FROM wip_lines

252: -- If the line is routing based and the assembly does not have a routing, default the first unit start date to be the same as the first unit cpl date
253:
254: IF g_RepSchedule_rec.line_id IS NOT NULL THEN
255: SELECT line_schedule_type INTO l_line_sch_type
256: FROM wip_lines
257: WHERE line_id = g_RepSchedule_rec.line_id;
258:
259: IF l_line_sch_type = 1 THEN --DO not default for Fixed LT lines
260: RETURN NULL;

Line 301: FROM wip_lines

297: -- If the line is routing based and the assembly does not have a routing, default the last unit completion date to be the same as the last unit start DATE.
298:
299: IF g_RepSchedule_rec.line_id IS NOT NULL THEN
300: SELECT line_schedule_type INTO l_line_sch_type
301: FROM wip_lines
302: WHERE line_id = g_RepSchedule_rec.line_id;
303:
304:
305: IF l_line_sch_type = 1 THEN --DO not default for Fixed LT lines

Line 350: FROM wip_lines

346: -- If the line is routing based and the assembly does not have a routing, default the last unit start date to be the same as the last unit cpl DATE.
347:
348: IF g_RepSchedule_rec.line_id IS NOT NULL THEN
349: SELECT line_schedule_type INTO l_line_sch_type
350: FROM wip_lines
351: WHERE line_id = g_RepSchedule_rec.line_id;
352:
353:
354: IF l_line_sch_type = 1 THEN --DO not default for Fixed LT lines