APPS.OE_INTERNAL_REQUISITION_PVT dependencies on OE_ORDER_LINES_ALL

Line 47: , oe_order_lines_all l

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

Line 845: , oe_order_lines_all l

841:
842: select l.line_id, l.header_id
843: into l_line_id, l_header_id
844: from oe_order_headers_all h
845: , oe_order_lines_all l
846: , oe_order_holds_all oh
847: , oe_hold_sources_all hs
848: -- OE_Order_Header_All table is used in this query to use
849: -- the OE_Order_Headers_N7 index for performance reasons

Line 991: from oe_order_lines_all l

987:
988: --
989: CURSOR All_Order_Lines (v_order_header_id NUMBER) IS
990: select l.line_id
991: from oe_order_lines_all l
992: where l.header_id = v_order_header_id
993: and nvl(l.cancelled_flag,'N') = 'N';
994: --
995: l_API_name Constant Varchar2(30) := 'IS_IREQ_CHANGABLE';

Line 1338: from oe_order_lines_all l

1334: ) IS
1335: --
1336: CURSOR All_Order_Lines (v_order_header_id NUMBER) IS
1337: select l.line_id, l.header_id, l.ordered_quantity2
1338: from oe_order_lines_all l
1339: -- , oe_order_headers_all h
1340: where nvl(l.shipped_quantity,0) = 0
1341: -- and h.orig_sys_document_ref = p_internal_req_header_id
1342: -- and h.order_source_id = OE_Globals.G_ORDER_SOURCE_INTERNAL

Line 1578: from oe_order_lines_all

1574: CLOSE All_Order_Lines;
1575:
1576: select count(line_id)
1577: into l_count_of_lines
1578: from oe_order_lines_all
1579: where header_id = l_order_header_id
1580: and nvl(cancelled_flag,'N') = 'N';
1581:
1582: IF l_cancel_eligble_lin > 0 OR l_count_of_lines = 0 THEN