APPS.OE_INTERNAL_REQUISITION_PVT dependencies on OE_ORDER_HEADERS_ALL

Line 43: from oe_order_headers_all h

39: , l_line_ids_rec.header_id
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

Line 778: from oe_order_headers_all h

774: Begin
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

Line 971: from oe_order_headers_all h

967: END IF;
968: Begin
969: select h.header_id
970: into l_header_id
971: from oe_order_headers_all h
972: where h.source_document_id = p_internal_req_header_id
973: and h.order_source_id = OE_Globals.G_ORDER_SOURCE_INTERNAL
974: and h.open_flag = 'Y';
975:

Line 1207: -- , oe_order_headers_all h

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
1211: -- and h.header_id = v_order_header_id

Line 1373: from oe_order_headers_all h

1369:
1370: Begin
1371: select header_id
1372: into l_order_header_id
1373: from oe_order_headers_all h
1374: where h.source_document_id = l_req_hdr_id
1375: and h.order_source_id = OE_Globals.G_ORDER_SOURCE_INTERNAL
1376: and h.open_flag = 'Y';
1377: Exception