APPS.OE_PURCHASE_RELEASE_PVT dependencies on OE_ORDER_HEADERS

Line 109: FROM oe_order_headers

105: FROM hr_employees_current_v
106: WHERE employee_id = x_employee_id;
107: Cursor C_Payment_Type(x_header_id NUMBER) IS
108: SELECT payment_type_code
109: FROM oe_order_headers
110: WHERE header_id = x_header_id;
111: Cursor Req_Date (v_line_id NUMBER) is
112: SELECT REQUEST_DATE
113: FROM OE_ORDER_LINES

Line 347: FROM OE_ORDER_HEADERS_ALL

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

Line 1076: oe_order_headers sh

1072: 'Y', mp.material_account, nvl(msi.expense_account,
1073: mp.expense_account)), nvl(pla.location_id, -1)
1074: FROM po_location_associations pla, oe_order_lines_all sl,
1075: mtl_parameters mp, fnd_user fu, mtl_system_items msi,
1076: oe_order_headers sh
1077: WHERE sl.header_id = sh.header_id
1078: AND sl.line_id = p_line_id
1079: AND fu.user_id = sh.created_by
1080: AND sl.source_type_code is not null