DBA Data[Home] [Help]

APPS.OZF_MULTI_CURR_MIG_PVT dependencies on OZF_RESALE_LINES_ALL

Line 172: FROM ozf_resale_lines_all line

168: DECODE(object_type,'ORDER', (SELECT header.transactional_curr_code
169: FROM oe_order_headers_all header
170: WHERE header.header_id = object_id)
171: ,'TP_ORDER', (SELECT line.currency_code
172: FROM ozf_resale_lines_all line
173: WHERE line.resale_line_id = object_id)
174: ,'INVOICE', (SELECT invoice_currency_code
175: FROM ra_customer_trx_all
176: WHERE customer_trx_id = object_id)

Line 206: FROM ozf_resale_lines_all line

202: ,'EVEO',(SELECT currency_code_tc
203: FROM ams_event_offers_vl
204: WHERE event_offer_id = plan_id)
205: ,'PRIC',(SELECT line.currency_code
206: FROM ozf_resale_lines_all line
207: WHERE line.resale_line_id = object_id)
208: ),
209: last_updated_by = -2,
210: last_update_date = sysdate