170: trunc(nvl(rcv.currency_conversion_date, rcv.transaction_date)) rate_date,
171: rcv.source_document_code source_document_code
172: from rcv_transactions rcv,
173: po_headers_all poh,
174: financials_system_params_all fsp,
175: gl_sets_of_books poa_gl
176: where ( rcv.last_update_date between d_start_date and d_end_date or
177: poh.last_update_date between d_start_date and d_end_date
178: )
204: trunc(nvl(rcv.currency_conversion_date, rcv.transaction_date)) rate_date,
205: rcv.source_document_code source_document_code
206: from rcv_transactions rcv,
207: po_headers_all poh,
208: financials_system_params_all fsp,
209: gl_sets_of_books poa_gl
210: where rcv.last_update_date between d_start_date and d_end_date
211: and rcv.po_header_id = poh.po_header_id (+)
212: and poh.org_id = fsp.org_id (+)
223: trunc(nvl(rcv.currency_conversion_date, rcv.transaction_date)) rate_date,
224: rcv.source_document_code source_document_code
225: from rcv_transactions rcv,
226: po_headers_all poh,
227: financials_system_params_all fsp,
228: gl_sets_of_books poa_gl
229: where
230: poh.last_update_date between d_start_date and d_end_date
231: and rcv.po_header_id = poh.po_header_id (+)
414: PO_HEADERS_ALL POH,
415: RCV_SHIPMENT_HEADERS RSH,
416: RCV_SHIPMENT_LINES rsl,
417: gl_sets_of_books poa_gl,
418: financials_system_params_all fsp,
419: mtl_system_items item,
420: mtl_parameters param,
421: poa_dbi_rtx_rates rat
422: where
500: PO_HEADERS_ALL POH,
501: RCV_SHIPMENT_HEADERS RSH,
502: RCV_SHIPMENT_LINES rsl,
503: gl_sets_of_books poa_gl,
504: financials_system_params_all fsp,
505: mtl_system_items item,
506: mtl_parameters param,
507: poa_dbi_rtx_rates rat
508: where