APPS.CSP_SCH_INT_PVT dependencies on OE_ORDER_HEADERS_ALL

Line 767: from oe_order_lines_all oel, oe_order_headers_all oeh, csp_requirement_headers crh, csp_requirement_lines crl

763: AND crl.local_RESERVATION_ID IS NOT NULL;
764:
765: cursor cancel_order IS
766: select distinct oeh.header_id,crl.requirement_line_id
767: from oe_order_lines_all oel, oe_order_headers_all oeh, csp_requirement_headers crh, csp_requirement_lines crl
768: where crh.task_assignment_id = p_task_assignment_id
769: and crl.REQUIREMENT_HEADER_ID = crh.REQUIREMENT_HEADER_ID
770: and oel.line_id = crl.order_line_id
771: and oeh.header_id = oel.header_id

Line 944: ,oe_order_headers_all oeh

940: from csp_req_line_details crld
941: ,csp_requirement_lines crl
942: ,csp_requirement_headers crh
943: ,oe_order_lines_all oel
944: ,oe_order_headers_all oeh
945: where crh.task_assignment_id = p_task_assignment_id
946: and crl.requirement_header_id = crh.requirement_header_id
947: and crld.requirement_line_id = crl.requirement_line_id
948: and crld.source_type = 'IO'

Line 955: from oe_order_headers_all

951: order by oeh.header_id;
952:
953: CURSOR get_order_status(c_header_id NUMBER) IS
954: select flow_status_code
955: from oe_order_headers_all
956: where header_id = c_header_id;
957:
958: cursor get_line_details(c_order_header_id Number) is
959: select REQ_LINE_DETAIL_ID

Line 1132: ,oe_order_headers_all oeh

1128: from csp_req_line_details crld
1129: ,csp_requirement_lines crl
1130: ,csp_requirement_headers crh
1131: ,oe_order_lines_all oel
1132: ,oe_order_headers_all oeh
1133: where crh.task_assignment_id = p_task_assignment_id
1134: and crl.requirement_header_id = crh.requirement_header_id
1135: and crld.requirement_line_id = crl.requirement_line_id
1136: and crld.source_type = 'IO'

Line 5523: ,oe_order_headers_all oeh

5519: from csp_req_line_details crld
5520: ,csp_requirement_lines crl
5521: ,csp_requirement_headers crh
5522: ,oe_order_lines_all oel
5523: ,oe_order_headers_all oeh
5524: where crh.task_id = l_task_id
5525: and crl.requirement_header_id = crh.requirement_header_id
5526: and crld.requirement_line_id = crl.requirement_line_id
5527: and crld.source_type = 'IO'

Line 5534: from oe_order_headers_all

5530: order by oeh.header_id;
5531:
5532: CURSOR get_order_status(c_header_id NUMBER) IS
5533: select flow_status_code
5534: from oe_order_headers_all
5535: where header_id = c_header_id;
5536:
5537: cursor cleanup_needed IS
5538: select 'Y'