APPS.OE_INTERNAL_REQUISITION_PVT dependencies on OE_ORDER_LINES_ALL

Line 44: , oe_order_lines_all l

40: , l_line_ids_rec.ordered_quantity
41: , l_line_ids_rec.ordered_quantity2
42: , l_line_ids_rec.request_date
43: from oe_order_headers_all h
44: , oe_order_lines_all l
45: -- OE_Order_Header_All table is used in this query to use
46: -- the OE_Order_Headers_N7 index for performance reasons
47: where h.header_id = l.header_id
48: and h.source_document_id = p_internal_req_header_id

Line 779: , oe_order_lines_all l

775:
776: select l.line_id, l.header_id
777: into l_line_id, l_header_id
778: from oe_order_headers_all h
779: , oe_order_lines_all l
780: , oe_order_holds_all oh
781: , oe_hold_sources_all hs
782: -- OE_Order_Header_All table is used in this query to use
783: -- the OE_Order_Headers_N7 index for performance reasons

Line 899: from oe_order_lines_all l

895:
896: --
897: CURSOR All_Order_Lines (v_order_header_id NUMBER) IS
898: select l.line_id
899: from oe_order_lines_all l
900: where l.header_id = v_order_header_id
901: and nvl(l.cancelled_flag,'N') = 'N';
902: --
903: l_API_name Constant Varchar2(30) := 'IS_IREQ_CHANGABLE';

Line 1206: from oe_order_lines_all l

1202: ) IS
1203: --
1204: CURSOR All_Order_Lines (v_order_header_id NUMBER) IS
1205: select l.line_id, l.header_id, l.ordered_quantity2
1206: from oe_order_lines_all l
1207: -- , oe_order_headers_all h
1208: where nvl(l.shipped_quantity,0) = 0
1209: -- and h.orig_sys_document_ref = p_internal_req_header_id
1210: -- and h.order_source_id = OE_Globals.G_ORDER_SOURCE_INTERNAL

Line 1427: from oe_order_lines_all

1423: CLOSE All_Order_Lines;
1424:
1425: select count(line_id)
1426: into l_count_of_lines
1427: from oe_order_lines_all
1428: where header_id = l_order_header_id
1429: and nvl(cancelled_flag,'N') = 'N';
1430:
1431: IF l_cancel_eligble_lin > 0 OR l_count_of_lines = 0 THEN