APPS.POA_DBI_RCV_TXN_F_C dependencies on RCV_TRANSACTIONS

Line 172: from rcv_transactions rcv,

168: poh.currency_code txn_cur_code,
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

Line 206: from rcv_transactions rcv,

202: poh.currency_code txn_cur_code,
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

Line 225: from rcv_transactions rcv,

221: poh.currency_code txn_cur_code,
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

Line 411: from rcv_transactions val,

407: trunc(CASE WHEN (val.transaction_type<>'CORRECT') THEN val.transaction_date
408: ELSE par.transaction_date END) wms_grp_txn_date,
409: val.dropship_type_code,
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,

Line 412: rcv_transactions par,

408: ELSE par.transaction_date END) wms_grp_txn_date,
409: val.dropship_type_code,
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,

Line 497: from rcv_transactions val,

493: trunc(CASE WHEN (val.transaction_type<>'CORRECT') THEN val.transaction_date
494: ELSE par.transaction_date END) wms_grp_txn_date,
495: val.dropship_type_code,
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,

Line 498: rcv_transactions par,

494: ELSE par.transaction_date END) wms_grp_txn_date,
495: val.dropship_type_code,
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,

Line 671: from rcv_transactions rcv

667: ret DATE;
668: begin
669: SELECT rcv.transaction_date
670: INTO ret
671: from rcv_transactions rcv
672: where rcv.transaction_id = txn_id;
673: RETURN ret;
674: END GET_DATE;
675:

Line 681: from rcv_transactions rcv

677: ret date;
678: begin
679: SELECT rcv.transaction_date
680: INTO ret
681: from rcv_transactions rcv
682: where rcv.parent_transaction_id <= 0
683: start with rcv.transaction_id = txn_id
684: connect by prior rcv.parent_transaction_id = rcv.transaction_id;
685: RETURN ret;