APPS.OE_INTERNAL_REQUISITION_PVT dependencies on OE_ORDER_HEADERS_ALL

Line 46: from oe_order_headers_all h

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

Line 844: from oe_order_headers_all h

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

Line 1082: from oe_order_headers_all h

1078: END IF;
1079: Begin
1080: select h.header_id
1081: into l_header_id
1082: from oe_order_headers_all h
1083: where h.source_document_id = p_internal_req_header_id
1084: and h.order_source_id = OE_Globals.G_ORDER_SOURCE_INTERNAL
1085: and h.open_flag = 'Y';
1086:

Line 1339: -- , oe_order_headers_all h

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

Line 1524: from oe_order_headers_all h

1520:
1521: Begin
1522: select header_id
1523: into l_order_header_id
1524: from oe_order_headers_all h
1525: where h.source_document_id = l_req_hdr_id
1526: and h.order_source_id = OE_Globals.G_ORDER_SOURCE_INTERNAL
1527: and h.open_flag = 'Y';
1528: Exception