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 815: FROM wip_lines

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

Line 1955: FROM wip_lines

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

Line 2084: FROM wip_lines

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

Line 2198: FROM wip_lines

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

Line 2774: FROM wip_lines

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

Line 2961: FROM wip_lines

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

Line 3445: FROM wip_lines

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

Line 3664: FROM wip_lines

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

Line 3844: FROM wip_lines

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

Line 4651: from wip_lines

4647: l_start_time := to_char(p_start_date,'SSSSS');
4648:
4649: select start_time, stop_time, 3600/maximum_rate
4650: into l_line_start_time, l_line_end_time, l_sec_rate
4651: from wip_lines
4652: where organization_id = p_org_id
4653: and line_id = p_line_id;
4654:
4655: if (l_line_end_time <= l_line_start_time) then