APPS.CSP_PARTS_ORDER dependencies on CSP_REQUIREMENT_LINES

Line 4915: csp_requirement_lines cl,

4911: cursor c_get_arrival_date is
4912: SELECT csp.arrival_date
4913: FROM CSP_SHIPPING_DETAILS_V csp,
4914: csp_requirement_headers ch,
4915: csp_requirement_lines cl,
4916: csp_req_line_details cld
4917: WHERE csp.organization_id = l_ship_from_org_id
4918: AND csp.shipping_method = p_ship_method
4919: AND cld.source_id = p_oe_line_id

Line 5104: FROM csp_requirement_lines cl,

5100: l_cancel_reason varchar2(200);
5101:
5102: cursor check_io_status is
5103: SELECT count(1)
5104: FROM csp_requirement_lines cl,
5105: csp_req_line_details cld,
5106: oe_order_lines_all oel
5107: WHERE cl.requirement_header_id = p_req_header_id
5108: AND cl.requirement_line_id = cld.requirement_line_id

Line 5115: FROM csp_requirement_lines cl,

5111: AND oel.booked_flag = 'Y';
5112:
5113: cursor get_booked_order_num is
5114: SELECT oeh.order_number
5115: FROM csp_requirement_lines cl,
5116: csp_req_line_details cld,
5117: oe_order_lines_all oel,
5118: oe_order_headers_all oeh
5119: WHERE cl.requirement_header_id = p_req_header_id

Line 5129: FROM csp_requirement_lines cl,

5125: AND rownum = 1;
5126:
5127: cursor get_order_header_ids is
5128: SELECT distinct oel.header_id
5129: FROM csp_requirement_lines cl,
5130: csp_req_line_details cld,
5131: oe_order_lines_all oel
5132: WHERE cl.requirement_header_id = p_req_header_id
5133: AND cl.requirement_line_id = cld.requirement_line_id