eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_GL_INTERFACE_PVT dependencies on OE_ORDER_LINES_ALL

Line 309: , oe_order_lines_all ol

305: CURSOR get_revenue_acct_csr1(p_utiz_id in number) IS
306: select cgl.code_combination_id
307: from ozf_funds_utilized_all_b fu
308: , oe_price_adjustments pa
309: , oe_order_lines_all ol
310: , oe_order_headers_all oh
311: , ra_customer_trx_lines_all ctl
312: , ra_cust_trx_line_gl_dist_all cgl
313: where fu.price_adjustment_id = pa.price_adjustment_id

Line 330: , oe_order_lines_all ol

326: CURSOR get_revenue_acct_csr2(p_utiz_id in number) IS
327: select cgl.code_combination_id
328: from ozf_funds_utilized_all_b fu
329: , oe_price_adjustments pa
330: , oe_order_lines_all ol
331: , oe_order_headers_all oh
332: , ra_customer_trx_lines_all ctl
333: , ra_cust_trx_line_gl_dist_all cgl
334: where fu.price_adjustment_id = pa.price_adjustment_id

Line 352: , oe_order_lines_all ol

348: select oh.order_number
349: , ol.line_number
350: from ozf_funds_utilized_all_b fu
351: , oe_price_adjustments pa
352: , oe_order_lines_all ol
353: , oe_order_headers_all oh
354: where fu.price_adjustment_id = pa.price_adjustment_id
355: and ol.line_id = pa.line_id
356: and ol.header_id = oh.header_id