DBA Data[Home] [Help]

APPS.POA_DBI_RCV_TXN_F_C dependencies on FINANCIALS_SYSTEM_PARAMS_ALL

Line 174: financials_system_params_all fsp,

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: )

Line 208: financials_system_params_all fsp,

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 (+)

Line 227: financials_system_params_all fsp,

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 (+)

Line 418: financials_system_params_all fsp,

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

Line 504: financials_system_params_all fsp,

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