DBA Data[Home] [Help]

APPS.OZF_MULTI_CURR_MIG_PVT dependencies on RA_CUSTOMER_TRX_ALL

Line 175: FROM ra_customer_trx_all

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)
177: ,'PCHO', (SELECT currency_code
178: FROM po_headers_all
179: WHERE po_header_id = object_id)

Line 181: FROM ra_customer_trx_all

177: ,'PCHO', (SELECT currency_code
178: FROM po_headers_all
179: WHERE po_header_id = object_id)
180: ,'CM', (SELECT invoice_currency_code
181: FROM ra_customer_trx_all
182: WHERE customer_trx_id = object_id)
183: ,'DM', (SELECT invoice_currency_code
184: FROM ra_customer_trx_all
185: WHERE customer_trx_id = object_id)

Line 184: FROM ra_customer_trx_all

180: ,'CM', (SELECT invoice_currency_code
181: FROM ra_customer_trx_all
182: WHERE customer_trx_id = object_id)
183: ,'DM', (SELECT invoice_currency_code
184: FROM ra_customer_trx_all
185: WHERE customer_trx_id = object_id)
186: ,(SELECT NVL(transaction_currency_code,fund_request_curr_code)
187: FROM ozf_offers
188: WHERE qp_list_header_id=plan_id)