APPS.OE_DELAYED_REQUESTS_UTIL dependencies on OE_ORDER_HEADERS

Line 4030: FROM oe_order_headers_all h, oe_order_lines l

4026: x_line_rec => l_orig_line_rec);
4027:
4028: SELECT /* MOAC_SQL_CHANGE */ h.order_number
4029: INTO l_order_number
4030: FROM oe_order_headers_all h, oe_order_lines l
4031: WHERE h.header_id = l.header_id
4032: AND h.header_id = l_orig_line_rec.header_id
4033: AND rownum = 1;
4034:

Line 4347: FROM oe_order_headers_all h, oe_order_lines l

4343: x_line_rec => l_orig_line_rec);
4344:
4345: SELECT /* MOAC_SQL_CHANGE */ h.order_number
4346: INTO l_order_number
4347: FROM oe_order_headers_all h, oe_order_lines l
4348: WHERE h.header_id = l.header_id
4349: AND h.header_id = l_orig_line_rec.header_id
4350: AND rownum = 1;
4351:

Line 5157: FROM OE_ORDER_HEADERS h,

5153: l_pricing_quantity_uom,
5154: l_order_quantity_uom,
5155: l_user_item_description,
5156: l_global_attribute_category
5157: FROM OE_ORDER_HEADERS h,
5158: OE_ORDER_LINES_all l
5159: WHERE l.HEADER_ID = h.HEADER_ID
5160: AND l.LINE_ID = l_line_id;
5161: -- incl. 3 parameters l_orig_sys_doc_ref,l_orig_sys_line_ref,l_order_src_id

Line 5661: FROM OE_ORDER_HEADERS

5657:
5658: Cursor ord_hdr_cur (p_header_id in number) is
5659: SELECT created_by
5660: ,org_id
5661: FROM OE_ORDER_HEADERS
5662: WHERE header_id = p_header_id;
5663:
5664: Cursor ord_line_cur (p_header_id in number) is
5665: SELECT line_id

Line 5794: Update OE_Order_Headers

5790: --if it returns success Update the Internal Sales Order with the Req header id and Req line Ids
5791: IF l_int_req_ret_sts = FND_API.G_RET_STS_SUCCESS THEN
5792:
5793: --Update the header with the requisition header id
5794: Update OE_Order_Headers
5795: set source_document_Id = l_req_header_rec.requisition_header_id
5796: ,orig_sys_document_ref = l_req_header_rec.segment1
5797: ,source_document_type_id = OE_GLOBALS.G_ORDER_SOURCE_INTERNAL -- i.e 10 for internal
5798: ,order_source_id = OE_GLOBALS.G_ORDER_SOURCE_INTERNAL --i.e 10 for internal

Line 6060: FROM oe_order_headers

6056:
6057:
6058: SELECT order_source_id, orig_sys_document_ref, sold_to_org_id, change_sequence
6059: INTO l_order_source_id, l_orig_sys_document_ref, l_sold_to_org_id, l_change_sequence
6060: FROM oe_order_headers
6061: WHERE header_id=l_header_id;
6062:
6063: /* to fix issue in bug 3478862, now retrieve key information from base table
6064: l_order_source_id := to_number(l_request_rec.param2);