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_UTILITIES_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 2005: FROM ap_invoice_distributions_all

2001: -- (NULL). The status should be needs reapproval (N).
2002: --
2003: CURSOR approval_cursor IS
2004: SELECT match_status_flag
2005: FROM ap_invoice_distributions_all
2006: WHERE invoice_id = p_invoice_id
2007: UNION
2008: SELECT 'N'
2009: FROM ap_invoice_distributions_all

Line 2009: FROM ap_invoice_distributions_all

2005: FROM ap_invoice_distributions_all
2006: WHERE invoice_id = p_invoice_id
2007: UNION
2008: SELECT 'N'
2009: FROM ap_invoice_distributions_all
2010: WHERE invoice_id = p_invoice_id
2011: AND match_status_flag IS NULL
2012: AND EXISTS
2013: (SELECT 'There are both untested and tested lines'

Line 2014: FROM ap_invoice_distributions_all

2010: WHERE invoice_id = p_invoice_id
2011: AND match_status_flag IS NULL
2012: AND EXISTS
2013: (SELECT 'There are both untested and tested lines'
2014: FROM ap_invoice_distributions_all
2015: WHERE invoice_id = p_invoice_id
2016: AND match_status_flag IN ('T','A'))
2017: UNION -- Bug 6866672
2018: SELECT 'N'

Line 2025: FROM ap_invoice_distributions_all

2021: AND ai.invoice_id = ail.invoice_id
2022: AND ai.cancelled_date is NULL
2023: AND NOT EXISTS
2024: (SELECT 1
2025: FROM ap_invoice_distributions_all
2026: WHERE invoice_id = p_invoice_id
2027: AND invoice_line_number = ail.line_number)
2028: AND ail.amount <> 0; -- Bug 6911199. Should ignore 0 Line Amounts.(Also one test case is an open issue)
2029: