APPS.OE_PURCHASE_RELEASE_PVT dependencies on OE_ORDER_HEADERS

Line 111: FROM oe_order_headers

107: FROM PER_WORKFORCE_CURRENT_X --hr_employees_current_v 9281079
108: WHERE person_id = x_employee_id;
109: Cursor C_Payment_Type(x_header_id NUMBER) IS
110: SELECT payment_type_code
111: FROM oe_order_headers
112: WHERE header_id = x_header_id;
113: Cursor Req_Date (v_line_id NUMBER) is
114: SELECT REQUEST_DATE
115: FROM OE_ORDER_LINES

Line 350: FROM OE_ORDER_HEADERS_ALL

346: END IF;
347: --R12.MOAC
348: SELECT nvl(ORDER_SOURCE_ID,0),nvl(SOURCE_DOCUMENT_TYPE_ID,0),org_id
349: INTO l_order_source_id,l_source_document_type_id,l_ou_id
350: FROM OE_ORDER_HEADERS_ALL
351: WHERE HEADER_ID = l_drop_ship_line_rec.header_id;
352:
353: IF l_debug_level > 0 THEN
354: oe_debug_pub.add('Order source id for this order is '||to_char ( l_order_source_id ) , 5 ) ;

Line 1111: oe_order_headers sh

1107: 'Y', mp.material_account, nvl(msi.expense_account,
1108: mp.expense_account)), nvl(pla.location_id, -1)
1109: FROM po_location_associations pla, oe_order_lines_all sl,
1110: mtl_parameters mp, fnd_user fu, mtl_system_items msi,
1111: oe_order_headers sh
1112: WHERE sl.header_id = sh.header_id
1113: AND sl.line_id = p_line_id
1114: AND fu.user_id = sh.created_by
1115: AND sl.source_type_code is not null