DBA Data[Home] [Help]

APPS.POA_DBI_RCV_TXN_F_C dependencies on PO_HEADERS_ALL

Line 173: po_headers_all poh,

169: poa_gl.currency_code func_cur_code,
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

Line 207: po_headers_all poh,

203: poa_gl.currency_code func_cur_code,
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 (+)

Line 226: po_headers_all poh,

222: poa_gl.currency_code func_cur_code,
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

Line 414: PO_HEADERS_ALL POH,

410: val.inv_transaction_id
411: from rcv_transactions val,
412: rcv_transactions par,
413: poa_dbi_rtx_inc inc,
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,

Line 500: PO_HEADERS_ALL POH,

496: val.inv_transaction_id
497: from rcv_transactions val,
498: rcv_transactions par,
499: poa_dbi_rtx_inc inc,
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,