APPS.CSP_SCH_INT_PVT dependencies on OE_ORDER_LINES_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 943: ,oe_order_lines_all oel

939: select oeh.header_id, crld.req_line_detail_id
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

Line 960: from csp_req_line_details crld,oe_order_lines_all oel

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
960: from csp_req_line_details crld,oe_order_lines_all oel
961: where crld.source_id = oel.line_id
962: and crld.source_type = 'IO'
963: and oel.header_id = c_order_header_id;
964:

Line 1131: ,oe_order_lines_all oel

1127: select distinct oeh.header_id, oel.line_id
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

Line 5522: ,oe_order_lines_all oel

5518: select oeh.header_id, crld.req_line_detail_id
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

Line 5545: from csp_req_line_details crld,oe_order_lines_all oel

5541: and ( CANCELLED_FLAG = 'Y' or rejected_flag = 'Y');
5542:
5543: cursor get_line_details(c_order_header_id Number) is
5544: select REQ_LINE_DETAIL_ID
5545: from csp_req_line_details crld,oe_order_lines_all oel
5546: where crld.source_id = oel.line_id
5547: and crld.source_type = 'IO'
5548: and oel.header_id = c_order_header_id;
5549:

Line 5608: oe_order_lines_all oola,csp_req_line_details crld,

5604: crld.requirement_line_id requirement_line_id,rcl.quantity_shipped quantity_shipped,
5605: rcl.quantity_received quantity_received,crld.req_line_detail_id req_line_detail_id
5606: from mtl_material_transactions mmt,RCV_SHIPMENT_headers rsh,
5607: rcv_shipment_lines rcl,
5608: oe_order_lines_all oola,csp_req_line_details crld,
5609: csp_requirement_lines crl,
5610: csp_requirement_headers crh
5611: where mmt.transaction_id = p_transaction_id
5612: and mmt.shipment_number = rsh.shipment_num

Line 5628: oe_order_lines_all oola,csp_req_line_details crld,

5624: crld.source_id line_id, mmt.transaction_uom uom,crh.need_by_date need_by_date,
5625: crld.requirement_line_id requirement_line_id, mmt.transaction_quantity quantity_shipped,
5626: mmt.transaction_quantity quantity_received,crld.req_line_detail_id req_line_detail_id
5627: from mtl_material_transactions mmt,
5628: oe_order_lines_all oola,csp_req_line_details crld,
5629: csp_requirement_lines crl,csp_requirement_headers crh
5630: where mmt.transaction_id = p_transaction_id
5631: and oola.source_document_id = mmt.transaction_source_id
5632: and crld.source_id = oola.line_id