APPS.AP_UTILITIES_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 2001: FROM ap_invoice_distributions_all

1997: -- (NULL). The status should be needs reapproval (N).
1998: --
1999: CURSOR approval_cursor IS
2000: SELECT match_status_flag
2001: FROM ap_invoice_distributions_all
2002: WHERE invoice_id = p_invoice_id
2003: UNION
2004: SELECT 'N'
2005: FROM ap_invoice_distributions_all

Line 2005: FROM ap_invoice_distributions_all

2001: FROM ap_invoice_distributions_all
2002: WHERE invoice_id = p_invoice_id
2003: UNION
2004: SELECT 'N'
2005: FROM ap_invoice_distributions_all
2006: WHERE invoice_id = p_invoice_id
2007: AND match_status_flag IS NULL
2008: AND EXISTS
2009: (SELECT 'There are both untested and tested lines'

Line 2010: FROM ap_invoice_distributions_all

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

Line 2021: FROM ap_invoice_distributions_all

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