DBA Data[Home] [Help]

APPS.OZF_FUND_UTILIZED_PVT dependencies on OE_ORDER_HEADERS_ALL

Line 314: FROM oe_order_headers_all

310: WHERE line_id = p_line_id;
311:
312: CURSOR c_order_num (p_header_id IN NUMBER) IS
313: SELECT order_number
314: FROM oe_order_headers_all
315: WHERE header_id = p_header_id;
316:
317: CURSOR c_invoice_date(p_line_id IN NUMBER, p_order_number IN VARCHAR2) IS
318: SELECT cust.trx_date -- transaction(invoice) date

Line 334: SELECT org_id FROM oe_order_headers_all

330:
331: -- 6657242
332: -- Cursor to get the org_id for order
333: CURSOR c_order_org_id (p_header_id IN NUMBER)IS
334: SELECT org_id FROM oe_order_headers_all
335: WHERE header_id = p_header_id;
336:
337: -- Cursor to get the org_id for third party order
338: CURSOR c_tp_order_org_id (p_batch_id IN NUMBER)IS