DBA Data[Home] [Help]

APPS.OZF_GL_INTERFACE_PVT dependencies on OE_ORDER_HEADERS_ALL

Line 310: , oe_order_headers_all oh

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
314: and ol.line_id = pa.line_id

Line 331: , oe_order_headers_all oh

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
335: and ol.line_id = pa.line_id

Line 353: , oe_order_headers_all oh

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
357: and fu.utilization_id = p_utiz_id;