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_INVOICES_ALL

Line 2019: FROM ap_invoice_lines_all ail, ap_invoices_all ai

2015: WHERE invoice_id = p_invoice_id
2016: AND match_status_flag IN ('T','A'))
2017: UNION -- Bug 6866672
2018: SELECT 'N'
2019: FROM ap_invoice_lines_all ail, ap_invoices_all ai
2020: WHERE ai.invoice_id = p_invoice_id
2021: AND ai.invoice_id = ail.invoice_id
2022: AND ai.cancelled_date is NULL
2023: AND NOT EXISTS

Line 2041: FROM ap_invoices_all

2037: -- Get the org_id
2038: --
2039: SELECT org_id
2040: INTO l_org_id
2041: FROM ap_invoices_all
2042: WHERE invoice_id = p_invoice_id;
2043:
2044: ---------------------------------------------------------------------
2045: l_debug_info := 'Getting encumbrance flag';

Line 2075: FROM ap_invoices_all ai

2071: BEGIN
2072:
2073: SELECT nvl(ai.force_revalidation_flag, 'N')
2074: INTO l_force_revalidation_flag
2075: FROM ap_invoices_all ai
2076: WHERE ai.invoice_id = p_invoice_id;
2077:
2078: EXCEPTION
2079: WHEN OTHERS THEN

Line 2201: FROM ap_invoices_all AI

2197:
2198: SELECT nvl(AI.invoice_amount,0)- l_prepay_amount
2199: - nvl(AP_INVOICES_UTILITY_PKG.get_amount_withheld(p_invoice_id),0)
2200: INTO l_net_inv_amount
2201: FROM ap_invoices_all AI
2202: WHERE AI.invoice_id = p_invoice_id;
2203:
2204:
2205: RETURN(l_net_inv_amount);

Line 2872: l_attribute_category AP_INVOICES_ALL.attribute_category%TYPE;

2868:
2869: l_pa_installed VARCHAR2(10);
2870: l_status VARCHAR2(10);
2871: l_industry VARCHAR2(10);
2872: l_attribute_category AP_INVOICES_ALL.attribute_category%TYPE;
2873: l_attribute1 AP_INVOICES_ALL.attribute1%TYPE;
2874: l_attribute2 AP_INVOICES_ALL.attribute2%TYPE;
2875: l_attribute3 AP_INVOICES_ALL.attribute3%TYPE;
2876: l_attribute4 AP_INVOICES_ALL.attribute4%TYPE;

Line 2873: l_attribute1 AP_INVOICES_ALL.attribute1%TYPE;

2869: l_pa_installed VARCHAR2(10);
2870: l_status VARCHAR2(10);
2871: l_industry VARCHAR2(10);
2872: l_attribute_category AP_INVOICES_ALL.attribute_category%TYPE;
2873: l_attribute1 AP_INVOICES_ALL.attribute1%TYPE;
2874: l_attribute2 AP_INVOICES_ALL.attribute2%TYPE;
2875: l_attribute3 AP_INVOICES_ALL.attribute3%TYPE;
2876: l_attribute4 AP_INVOICES_ALL.attribute4%TYPE;
2877: l_attribute5 AP_INVOICES_ALL.attribute5%TYPE;

Line 2874: l_attribute2 AP_INVOICES_ALL.attribute2%TYPE;

2870: l_status VARCHAR2(10);
2871: l_industry VARCHAR2(10);
2872: l_attribute_category AP_INVOICES_ALL.attribute_category%TYPE;
2873: l_attribute1 AP_INVOICES_ALL.attribute1%TYPE;
2874: l_attribute2 AP_INVOICES_ALL.attribute2%TYPE;
2875: l_attribute3 AP_INVOICES_ALL.attribute3%TYPE;
2876: l_attribute4 AP_INVOICES_ALL.attribute4%TYPE;
2877: l_attribute5 AP_INVOICES_ALL.attribute5%TYPE;
2878: l_attribute6 AP_INVOICES_ALL.attribute6%TYPE;

Line 2875: l_attribute3 AP_INVOICES_ALL.attribute3%TYPE;

2871: l_industry VARCHAR2(10);
2872: l_attribute_category AP_INVOICES_ALL.attribute_category%TYPE;
2873: l_attribute1 AP_INVOICES_ALL.attribute1%TYPE;
2874: l_attribute2 AP_INVOICES_ALL.attribute2%TYPE;
2875: l_attribute3 AP_INVOICES_ALL.attribute3%TYPE;
2876: l_attribute4 AP_INVOICES_ALL.attribute4%TYPE;
2877: l_attribute5 AP_INVOICES_ALL.attribute5%TYPE;
2878: l_attribute6 AP_INVOICES_ALL.attribute6%TYPE;
2879: l_attribute7 AP_INVOICES_ALL.attribute7%TYPE;

Line 2876: l_attribute4 AP_INVOICES_ALL.attribute4%TYPE;

2872: l_attribute_category AP_INVOICES_ALL.attribute_category%TYPE;
2873: l_attribute1 AP_INVOICES_ALL.attribute1%TYPE;
2874: l_attribute2 AP_INVOICES_ALL.attribute2%TYPE;
2875: l_attribute3 AP_INVOICES_ALL.attribute3%TYPE;
2876: l_attribute4 AP_INVOICES_ALL.attribute4%TYPE;
2877: l_attribute5 AP_INVOICES_ALL.attribute5%TYPE;
2878: l_attribute6 AP_INVOICES_ALL.attribute6%TYPE;
2879: l_attribute7 AP_INVOICES_ALL.attribute7%TYPE;
2880: l_attribute8 AP_INVOICES_ALL.attribute8%TYPE;

Line 2877: l_attribute5 AP_INVOICES_ALL.attribute5%TYPE;

2873: l_attribute1 AP_INVOICES_ALL.attribute1%TYPE;
2874: l_attribute2 AP_INVOICES_ALL.attribute2%TYPE;
2875: l_attribute3 AP_INVOICES_ALL.attribute3%TYPE;
2876: l_attribute4 AP_INVOICES_ALL.attribute4%TYPE;
2877: l_attribute5 AP_INVOICES_ALL.attribute5%TYPE;
2878: l_attribute6 AP_INVOICES_ALL.attribute6%TYPE;
2879: l_attribute7 AP_INVOICES_ALL.attribute7%TYPE;
2880: l_attribute8 AP_INVOICES_ALL.attribute8%TYPE;
2881: l_attribute9 AP_INVOICES_ALL.attribute9%TYPE;

Line 2878: l_attribute6 AP_INVOICES_ALL.attribute6%TYPE;

2874: l_attribute2 AP_INVOICES_ALL.attribute2%TYPE;
2875: l_attribute3 AP_INVOICES_ALL.attribute3%TYPE;
2876: l_attribute4 AP_INVOICES_ALL.attribute4%TYPE;
2877: l_attribute5 AP_INVOICES_ALL.attribute5%TYPE;
2878: l_attribute6 AP_INVOICES_ALL.attribute6%TYPE;
2879: l_attribute7 AP_INVOICES_ALL.attribute7%TYPE;
2880: l_attribute8 AP_INVOICES_ALL.attribute8%TYPE;
2881: l_attribute9 AP_INVOICES_ALL.attribute9%TYPE;
2882: l_attribute10 AP_INVOICES_ALL.attribute10%TYPE;

Line 2879: l_attribute7 AP_INVOICES_ALL.attribute7%TYPE;

2875: l_attribute3 AP_INVOICES_ALL.attribute3%TYPE;
2876: l_attribute4 AP_INVOICES_ALL.attribute4%TYPE;
2877: l_attribute5 AP_INVOICES_ALL.attribute5%TYPE;
2878: l_attribute6 AP_INVOICES_ALL.attribute6%TYPE;
2879: l_attribute7 AP_INVOICES_ALL.attribute7%TYPE;
2880: l_attribute8 AP_INVOICES_ALL.attribute8%TYPE;
2881: l_attribute9 AP_INVOICES_ALL.attribute9%TYPE;
2882: l_attribute10 AP_INVOICES_ALL.attribute10%TYPE;
2883: l_attribute11 AP_INVOICES_ALL.attribute11%TYPE;

Line 2880: l_attribute8 AP_INVOICES_ALL.attribute8%TYPE;

2876: l_attribute4 AP_INVOICES_ALL.attribute4%TYPE;
2877: l_attribute5 AP_INVOICES_ALL.attribute5%TYPE;
2878: l_attribute6 AP_INVOICES_ALL.attribute6%TYPE;
2879: l_attribute7 AP_INVOICES_ALL.attribute7%TYPE;
2880: l_attribute8 AP_INVOICES_ALL.attribute8%TYPE;
2881: l_attribute9 AP_INVOICES_ALL.attribute9%TYPE;
2882: l_attribute10 AP_INVOICES_ALL.attribute10%TYPE;
2883: l_attribute11 AP_INVOICES_ALL.attribute11%TYPE;
2884: l_attribute12 AP_INVOICES_ALL.attribute12%TYPE;

Line 2881: l_attribute9 AP_INVOICES_ALL.attribute9%TYPE;

2877: l_attribute5 AP_INVOICES_ALL.attribute5%TYPE;
2878: l_attribute6 AP_INVOICES_ALL.attribute6%TYPE;
2879: l_attribute7 AP_INVOICES_ALL.attribute7%TYPE;
2880: l_attribute8 AP_INVOICES_ALL.attribute8%TYPE;
2881: l_attribute9 AP_INVOICES_ALL.attribute9%TYPE;
2882: l_attribute10 AP_INVOICES_ALL.attribute10%TYPE;
2883: l_attribute11 AP_INVOICES_ALL.attribute11%TYPE;
2884: l_attribute12 AP_INVOICES_ALL.attribute12%TYPE;
2885: l_attribute13 AP_INVOICES_ALL.attribute13%TYPE;

Line 2882: l_attribute10 AP_INVOICES_ALL.attribute10%TYPE;

2878: l_attribute6 AP_INVOICES_ALL.attribute6%TYPE;
2879: l_attribute7 AP_INVOICES_ALL.attribute7%TYPE;
2880: l_attribute8 AP_INVOICES_ALL.attribute8%TYPE;
2881: l_attribute9 AP_INVOICES_ALL.attribute9%TYPE;
2882: l_attribute10 AP_INVOICES_ALL.attribute10%TYPE;
2883: l_attribute11 AP_INVOICES_ALL.attribute11%TYPE;
2884: l_attribute12 AP_INVOICES_ALL.attribute12%TYPE;
2885: l_attribute13 AP_INVOICES_ALL.attribute13%TYPE;
2886: l_attribute14 AP_INVOICES_ALL.attribute14%TYPE;

Line 2883: l_attribute11 AP_INVOICES_ALL.attribute11%TYPE;

2879: l_attribute7 AP_INVOICES_ALL.attribute7%TYPE;
2880: l_attribute8 AP_INVOICES_ALL.attribute8%TYPE;
2881: l_attribute9 AP_INVOICES_ALL.attribute9%TYPE;
2882: l_attribute10 AP_INVOICES_ALL.attribute10%TYPE;
2883: l_attribute11 AP_INVOICES_ALL.attribute11%TYPE;
2884: l_attribute12 AP_INVOICES_ALL.attribute12%TYPE;
2885: l_attribute13 AP_INVOICES_ALL.attribute13%TYPE;
2886: l_attribute14 AP_INVOICES_ALL.attribute14%TYPE;
2887: l_attribute15 AP_INVOICES_ALL.attribute15%TYPE;

Line 2884: l_attribute12 AP_INVOICES_ALL.attribute12%TYPE;

2880: l_attribute8 AP_INVOICES_ALL.attribute8%TYPE;
2881: l_attribute9 AP_INVOICES_ALL.attribute9%TYPE;
2882: l_attribute10 AP_INVOICES_ALL.attribute10%TYPE;
2883: l_attribute11 AP_INVOICES_ALL.attribute11%TYPE;
2884: l_attribute12 AP_INVOICES_ALL.attribute12%TYPE;
2885: l_attribute13 AP_INVOICES_ALL.attribute13%TYPE;
2886: l_attribute14 AP_INVOICES_ALL.attribute14%TYPE;
2887: l_attribute15 AP_INVOICES_ALL.attribute15%TYPE;
2888: li_attribute_category AP_INVOICES_ALL.attribute_category%TYPE;

Line 2885: l_attribute13 AP_INVOICES_ALL.attribute13%TYPE;

2881: l_attribute9 AP_INVOICES_ALL.attribute9%TYPE;
2882: l_attribute10 AP_INVOICES_ALL.attribute10%TYPE;
2883: l_attribute11 AP_INVOICES_ALL.attribute11%TYPE;
2884: l_attribute12 AP_INVOICES_ALL.attribute12%TYPE;
2885: l_attribute13 AP_INVOICES_ALL.attribute13%TYPE;
2886: l_attribute14 AP_INVOICES_ALL.attribute14%TYPE;
2887: l_attribute15 AP_INVOICES_ALL.attribute15%TYPE;
2888: li_attribute_category AP_INVOICES_ALL.attribute_category%TYPE;
2889: li_attribute1 AP_INVOICE_LINES_ALL.attribute1%TYPE;

Line 2886: l_attribute14 AP_INVOICES_ALL.attribute14%TYPE;

2882: l_attribute10 AP_INVOICES_ALL.attribute10%TYPE;
2883: l_attribute11 AP_INVOICES_ALL.attribute11%TYPE;
2884: l_attribute12 AP_INVOICES_ALL.attribute12%TYPE;
2885: l_attribute13 AP_INVOICES_ALL.attribute13%TYPE;
2886: l_attribute14 AP_INVOICES_ALL.attribute14%TYPE;
2887: l_attribute15 AP_INVOICES_ALL.attribute15%TYPE;
2888: li_attribute_category AP_INVOICES_ALL.attribute_category%TYPE;
2889: li_attribute1 AP_INVOICE_LINES_ALL.attribute1%TYPE;
2890: li_attribute2 AP_INVOICE_LINES_ALL.attribute2%TYPE;

Line 2887: l_attribute15 AP_INVOICES_ALL.attribute15%TYPE;

2883: l_attribute11 AP_INVOICES_ALL.attribute11%TYPE;
2884: l_attribute12 AP_INVOICES_ALL.attribute12%TYPE;
2885: l_attribute13 AP_INVOICES_ALL.attribute13%TYPE;
2886: l_attribute14 AP_INVOICES_ALL.attribute14%TYPE;
2887: l_attribute15 AP_INVOICES_ALL.attribute15%TYPE;
2888: li_attribute_category AP_INVOICES_ALL.attribute_category%TYPE;
2889: li_attribute1 AP_INVOICE_LINES_ALL.attribute1%TYPE;
2890: li_attribute2 AP_INVOICE_LINES_ALL.attribute2%TYPE;
2891: li_attribute3 AP_INVOICE_LINES_ALL.attribute3%TYPE;

Line 2888: li_attribute_category AP_INVOICES_ALL.attribute_category%TYPE;

2884: l_attribute12 AP_INVOICES_ALL.attribute12%TYPE;
2885: l_attribute13 AP_INVOICES_ALL.attribute13%TYPE;
2886: l_attribute14 AP_INVOICES_ALL.attribute14%TYPE;
2887: l_attribute15 AP_INVOICES_ALL.attribute15%TYPE;
2888: li_attribute_category AP_INVOICES_ALL.attribute_category%TYPE;
2889: li_attribute1 AP_INVOICE_LINES_ALL.attribute1%TYPE;
2890: li_attribute2 AP_INVOICE_LINES_ALL.attribute2%TYPE;
2891: li_attribute3 AP_INVOICE_LINES_ALL.attribute3%TYPE;
2892: li_attribute4 AP_INVOICE_LINES_ALL.attribute4%TYPE;