APPS.MRP_LINE_SCHEDULE_ALGORITHM dependencies on WIP_LINES

Line 238: FROM wip_lines

234:
235: -- Fix bug 939061, add 24 hrs to stop_time if stop_time <= start_time
236: SELECT maximum_rate, start_time, stop_time
237: INTO v_hr_rate, v_line_start_time, v_line_stop_time
238: FROM wip_lines
239: WHERE line_id = p_line_id
240: AND organization_id = p_org_id;
241:
242: if (v_line_stop_time <= v_line_start_time) then

Line 814: FROM wip_lines

810: -- Obtain information on the hourly line rate, start time and end time of the line.
811:
812: SELECT maximum_rate, start_time, stop_time
813: INTO v_hr_line_rate, v_start_time, v_end_time
814: FROM wip_lines
815: WHERE line_id = p_line_id
816: AND organization_id = p_org_id;
817:
818: V_ERROR_LINE := 2;

Line 1954: FROM wip_lines

1950: -- time stamping flow schedules.
1951:
1952: SELECT maximum_rate, start_time, stop_time
1953: INTO v_hr_line_rate, v_start_time, v_end_time
1954: FROM wip_lines
1955: WHERE line_id = p_line_id
1956: AND organization_id = p_org_id;
1957:
1958: V_ERROR_LINE := 3;

Line 2083: FROM wip_lines

2079:
2080: IF p_time_tab.EXISTS(v_current_date) = FALSE THEN
2081: SELECT start_time
2082: INTO v_final_time
2083: FROM wip_lines
2084: WHERE line_id = p_line_id
2085: AND organization_id = p_org_id;
2086:
2087: V_ERROR_LINE := 6;

Line 2197: FROM wip_lines

2193:
2194: IF p_time_tab.EXISTS(v_current_date) = FALSE THEN
2195: SELECT start_time
2196: INTO v_final_time
2197: FROM wip_lines
2198: WHERE line_id = p_line_id
2199: AND organization_id = p_org_id;
2200:
2201: V_ERROR_LINE := 9;

Line 2773: FROM wip_lines

2769: -- time stamping flow schedules.
2770:
2771: SELECT maximum_rate, start_time, stop_time
2772: INTO v_hr_line_rate, v_start_time, v_end_time
2773: FROM wip_lines
2774: WHERE line_id = p_line_id
2775: AND organization_id = p_org_id;
2776:
2777: if (v_end_time <= v_start_time) then

Line 2960: FROM wip_lines

2956:
2957: IF p_time_tab.EXISTS(v_current_date) = FALSE THEN
2958: SELECT start_time
2959: INTO v_final_time
2960: FROM wip_lines
2961: WHERE line_id = p_line_id
2962: AND organization_id = p_org_id;
2963:
2964: V_ERROR_LINE := 14;

Line 3444: FROM wip_lines

3440: -- time stamping flow schedules.
3441:
3442: SELECT maximum_rate, start_time, stop_time
3443: INTO v_hr_line_rate, v_start_time, v_end_time
3444: FROM wip_lines
3445: WHERE line_id = p_line_id
3446: AND organization_id = p_org_id;
3447:
3448: V_ERROR_LINE := 2;

Line 3663: FROM wip_lines

3659:
3660: IF p_time_tab.EXISTS(v_current_date) = FALSE THEN
3661: SELECT start_time
3662: INTO v_final_time
3663: FROM wip_lines
3664: WHERE line_id = p_line_id
3665: AND organization_id = p_org_id;
3666:
3667: V_ERROR_LINE := 8;

Line 3843: FROM wip_lines

3839:
3840: IF p_time_tab.EXISTS(v_current_date) = FALSE THEN
3841: SELECT start_time
3842: INTO v_final_time
3843: FROM wip_lines
3844: WHERE line_id = p_line_id
3845: AND organization_id = p_org_id;
3846:
3847: V_ERROR_LINE := 10;

Line 4644: from wip_lines

4640: l_start_time := to_char(p_start_date,'SSSSS');
4641:
4642: select start_time, stop_time, 3600/maximum_rate
4643: into l_line_start_time, l_line_end_time, l_sec_rate
4644: from wip_lines
4645: where organization_id = p_org_id
4646: and line_id = p_line_id;
4647:
4648: if (l_line_end_time <= l_line_start_time) then