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.AP_AUTOSELECT_PKG dependencies on AP_INVOICES_UTILITY_PKG

Line 6460: nvl(AP_INVOICES_UTILITY_PKG.GET_RETAINED_TOTAL(si2.invoice_id, si2.org_id),0)),i.payment_cross_rate

6456: where si2.checkrun_id = p_checkrun_id
6457: and si2.invoice_id = i.invoice_id
6458: and si2.original_invoice_id is null
6459: group by si2.invoice_id,i.invoice_amount, decode(i.net_of_retainage_flag, 'Y', 0,
6460: nvl(AP_INVOICES_UTILITY_PKG.GET_RETAINED_TOTAL(si2.invoice_id, si2.org_id),0)),i.payment_cross_rate
6461: having abs((nvl(i.invoice_amount,0) - nvl(sum(si2.withholding_amount),0)
6462: - nvl(AP_INVOICES_UTILITY_PKG.get_amount_withheld(si2.invoice_id),0)
6463: + decode(i.net_of_retainage_flag, 'Y', 0,
6464: nvl(AP_INVOICES_UTILITY_PKG.GET_RETAINED_TOTAL(si2.invoice_id, si2.org_id),0)))*i.payment_cross_rate

Line 6462: - nvl(AP_INVOICES_UTILITY_PKG.get_amount_withheld(si2.invoice_id),0)

6458: and si2.original_invoice_id is null
6459: group by si2.invoice_id,i.invoice_amount, decode(i.net_of_retainage_flag, 'Y', 0,
6460: nvl(AP_INVOICES_UTILITY_PKG.GET_RETAINED_TOTAL(si2.invoice_id, si2.org_id),0)),i.payment_cross_rate
6461: having abs((nvl(i.invoice_amount,0) - nvl(sum(si2.withholding_amount),0)
6462: - nvl(AP_INVOICES_UTILITY_PKG.get_amount_withheld(si2.invoice_id),0)
6463: + decode(i.net_of_retainage_flag, 'Y', 0,
6464: nvl(AP_INVOICES_UTILITY_PKG.GET_RETAINED_TOTAL(si2.invoice_id, si2.org_id),0)))*i.payment_cross_rate
6465: /* retainage is returned as a negative */
6466: )

Line 6464: nvl(AP_INVOICES_UTILITY_PKG.GET_RETAINED_TOTAL(si2.invoice_id, si2.org_id),0)))*i.payment_cross_rate

6460: nvl(AP_INVOICES_UTILITY_PKG.GET_RETAINED_TOTAL(si2.invoice_id, si2.org_id),0)),i.payment_cross_rate
6461: having abs((nvl(i.invoice_amount,0) - nvl(sum(si2.withholding_amount),0)
6462: - nvl(AP_INVOICES_UTILITY_PKG.get_amount_withheld(si2.invoice_id),0)
6463: + decode(i.net_of_retainage_flag, 'Y', 0,
6464: nvl(AP_INVOICES_UTILITY_PKG.GET_RETAINED_TOTAL(si2.invoice_id, si2.org_id),0)))*i.payment_cross_rate
6465: /* retainage is returned as a negative */
6466: )
6467: < abs( nvl(sum(si2.discount_amount),0) + nvl(sum(si2.payment_amount),0)
6468: + nvl(get_prepay_with_tax(si2.invoice_id),0)