DBA Data[Home] [Help]

APPS.OZF_GL_INTERFACE_PVT dependencies on OE_PRICE_ADJUSTMENTS

Line 308: , oe_price_adjustments pa

304: --(and when profile 'OM: Show Discount Details on Invoice' is set to 'No')
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

Line 329: , oe_price_adjustments pa

325: --(and when profile 'OM: Show Discount Details on Invoice' is set to 'Yes')
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

Line 351: , oe_price_adjustments pa

347: CURSOR get_order_line_csr(p_utiz_id in number) IS
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