APPS.AP_PURGE_PKG dependencies on RCV_TRANSACTIONS

Line 965: from ap_invoice_distributions aid, rcv_transactions rcv

961:
962: DELETE FROM ap_purge_invoice_list PL
963: WHERE EXISTS (
964: select 'matched'
965: from ap_invoice_distributions aid, rcv_transactions rcv
966: where aid.invoice_id = PL.invoice_id
967: and aid.rcv_transaction_id = rcv.transaction_id
968: and rcv.last_update_date > g_activity_date);
969:

Line 1669: from rcv_transactions_interface rti

1665: or exists (select null
1666: from rcv_headers_interface rhi
1667: where rhi.vendor_id = pvl.vendor_id)
1668: or exists (select null
1669: from rcv_transactions_interface rti
1670: where rti.vendor_id = pvl.vendor_id);
1671:
1672:
1673: end if;

Line 2899: , rcv_transactions rcv

2895: SET PL.double_check_flag = 'N'
2896: WHERE EXISTS (
2897: SELECT 'matched'
2898: FROM ap_invoice_distributions aid
2899: , rcv_transactions rcv
2900: WHERE aid.invoice_id = PL.invoice_id
2901: and aid.rcv_transaction_id = rcv.transaction_id
2902: --Bug 1579474
2903: and rcv.last_update_date > g_activity_date

Line 3558: from rcv_transactions_interface rti

3554: from rcv_headers_interface rhi
3555: where rhi.vendor_id = pvl.vendor_id)
3556: or
3557: exists (select null
3558: from rcv_transactions_interface rti
3559: where rti.vendor_id = pvl.vendor_id));
3560: end if;
3561:
3562: if (g_chv_status = 'Y') then