eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_DEDUCTIONS dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 2170: DELETE AP_INVOICE_DISTRIBUTIONS_ALL WHERE invoice_id IN(

2166:
2167: DELETE AP_INVOICES_INTERFACE WHERE
2168: product_table = 'PA_DEDUCTIONS_ALL' and reference_key1 = to_char(p_dctn_req_id);
2169:
2170: DELETE AP_INVOICE_DISTRIBUTIONS_ALL WHERE invoice_id IN(
2171: SELECT invoice_id FROM AP_INVOICES_ALL WHERE
2172: product_table = 'PA_DEDUCTIONS_ALL' and reference_key1 = to_char(p_dctn_req_id));
2173:
2174: DELETE AP_INVOICE_LINES_ALL WHERE invoice_id IN(

Line 2391: (SELECT 1 FROM ap_invoice_distributions_all

2387: FROM ap_invoices_all apinv
2388: WHERE apinv.vendor_id = p_vendor_id
2389: AND apinv.vendor_site_id = p_vendor_site_id
2390: AND EXISTS
2391: (SELECT 1 FROM ap_invoice_distributions_all
2392: WHERE invoice_id = apinv.invoice_id
2393: AND parent_invoice_id = ( SELECT invoice_id from ap_invoices_all
2394: WHERE source = 'Oracle Project Accounting'
2395: AND invoice_type_lookup_code = 'DEBIT'