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 2015: FROM ap_invoice_lines_all ail, ap_invoices_all ai

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

Line 2037: FROM ap_invoices_all

2033: -- Get the org_id
2034: --
2035: SELECT org_id
2036: INTO l_org_id
2037: FROM ap_invoices_all
2038: WHERE invoice_id = p_invoice_id;
2039:
2040: ---------------------------------------------------------------------
2041: l_debug_info := 'Getting encumbrance flag';

Line 2071: FROM ap_invoices_all ai

2067: BEGIN
2068:
2069: SELECT nvl(ai.force_revalidation_flag, 'N')
2070: INTO l_force_revalidation_flag
2071: FROM ap_invoices_all ai
2072: WHERE ai.invoice_id = p_invoice_id;
2073:
2074: EXCEPTION
2075: WHEN OTHERS THEN

Line 2197: FROM ap_invoices_all AI

2193:
2194: SELECT nvl(AI.invoice_amount,0)- l_prepay_amount
2195: - nvl(AP_INVOICES_UTILITY_PKG.get_amount_withheld(p_invoice_id),0)
2196: INTO l_net_inv_amount
2197: FROM ap_invoices_all AI
2198: WHERE AI.invoice_id = p_invoice_id;
2199:
2200:
2201: RETURN(l_net_inv_amount);

Line 2863: l_attribute_category AP_INVOICES_ALL.attribute_category%TYPE;

2859:
2860: l_pa_installed VARCHAR2(10);
2861: l_status VARCHAR2(10);
2862: l_industry VARCHAR2(10);
2863: l_attribute_category AP_INVOICES_ALL.attribute_category%TYPE;
2864: l_attribute1 AP_INVOICES_ALL.attribute1%TYPE;
2865: l_attribute2 AP_INVOICES_ALL.attribute2%TYPE;
2866: l_attribute3 AP_INVOICES_ALL.attribute3%TYPE;
2867: l_attribute4 AP_INVOICES_ALL.attribute4%TYPE;

Line 2864: l_attribute1 AP_INVOICES_ALL.attribute1%TYPE;

2860: l_pa_installed VARCHAR2(10);
2861: l_status VARCHAR2(10);
2862: l_industry VARCHAR2(10);
2863: l_attribute_category AP_INVOICES_ALL.attribute_category%TYPE;
2864: l_attribute1 AP_INVOICES_ALL.attribute1%TYPE;
2865: l_attribute2 AP_INVOICES_ALL.attribute2%TYPE;
2866: l_attribute3 AP_INVOICES_ALL.attribute3%TYPE;
2867: l_attribute4 AP_INVOICES_ALL.attribute4%TYPE;
2868: l_attribute5 AP_INVOICES_ALL.attribute5%TYPE;

Line 2865: l_attribute2 AP_INVOICES_ALL.attribute2%TYPE;

2861: l_status VARCHAR2(10);
2862: l_industry VARCHAR2(10);
2863: l_attribute_category AP_INVOICES_ALL.attribute_category%TYPE;
2864: l_attribute1 AP_INVOICES_ALL.attribute1%TYPE;
2865: l_attribute2 AP_INVOICES_ALL.attribute2%TYPE;
2866: l_attribute3 AP_INVOICES_ALL.attribute3%TYPE;
2867: l_attribute4 AP_INVOICES_ALL.attribute4%TYPE;
2868: l_attribute5 AP_INVOICES_ALL.attribute5%TYPE;
2869: l_attribute6 AP_INVOICES_ALL.attribute6%TYPE;

Line 2866: l_attribute3 AP_INVOICES_ALL.attribute3%TYPE;

2862: l_industry VARCHAR2(10);
2863: l_attribute_category AP_INVOICES_ALL.attribute_category%TYPE;
2864: l_attribute1 AP_INVOICES_ALL.attribute1%TYPE;
2865: l_attribute2 AP_INVOICES_ALL.attribute2%TYPE;
2866: l_attribute3 AP_INVOICES_ALL.attribute3%TYPE;
2867: l_attribute4 AP_INVOICES_ALL.attribute4%TYPE;
2868: l_attribute5 AP_INVOICES_ALL.attribute5%TYPE;
2869: l_attribute6 AP_INVOICES_ALL.attribute6%TYPE;
2870: l_attribute7 AP_INVOICES_ALL.attribute7%TYPE;

Line 2867: l_attribute4 AP_INVOICES_ALL.attribute4%TYPE;

2863: l_attribute_category AP_INVOICES_ALL.attribute_category%TYPE;
2864: l_attribute1 AP_INVOICES_ALL.attribute1%TYPE;
2865: l_attribute2 AP_INVOICES_ALL.attribute2%TYPE;
2866: l_attribute3 AP_INVOICES_ALL.attribute3%TYPE;
2867: l_attribute4 AP_INVOICES_ALL.attribute4%TYPE;
2868: l_attribute5 AP_INVOICES_ALL.attribute5%TYPE;
2869: l_attribute6 AP_INVOICES_ALL.attribute6%TYPE;
2870: l_attribute7 AP_INVOICES_ALL.attribute7%TYPE;
2871: l_attribute8 AP_INVOICES_ALL.attribute8%TYPE;

Line 2868: l_attribute5 AP_INVOICES_ALL.attribute5%TYPE;

2864: l_attribute1 AP_INVOICES_ALL.attribute1%TYPE;
2865: l_attribute2 AP_INVOICES_ALL.attribute2%TYPE;
2866: l_attribute3 AP_INVOICES_ALL.attribute3%TYPE;
2867: l_attribute4 AP_INVOICES_ALL.attribute4%TYPE;
2868: l_attribute5 AP_INVOICES_ALL.attribute5%TYPE;
2869: l_attribute6 AP_INVOICES_ALL.attribute6%TYPE;
2870: l_attribute7 AP_INVOICES_ALL.attribute7%TYPE;
2871: l_attribute8 AP_INVOICES_ALL.attribute8%TYPE;
2872: l_attribute9 AP_INVOICES_ALL.attribute9%TYPE;

Line 2869: l_attribute6 AP_INVOICES_ALL.attribute6%TYPE;

2865: l_attribute2 AP_INVOICES_ALL.attribute2%TYPE;
2866: l_attribute3 AP_INVOICES_ALL.attribute3%TYPE;
2867: l_attribute4 AP_INVOICES_ALL.attribute4%TYPE;
2868: l_attribute5 AP_INVOICES_ALL.attribute5%TYPE;
2869: l_attribute6 AP_INVOICES_ALL.attribute6%TYPE;
2870: l_attribute7 AP_INVOICES_ALL.attribute7%TYPE;
2871: l_attribute8 AP_INVOICES_ALL.attribute8%TYPE;
2872: l_attribute9 AP_INVOICES_ALL.attribute9%TYPE;
2873: l_attribute10 AP_INVOICES_ALL.attribute10%TYPE;

Line 2870: l_attribute7 AP_INVOICES_ALL.attribute7%TYPE;

2866: l_attribute3 AP_INVOICES_ALL.attribute3%TYPE;
2867: l_attribute4 AP_INVOICES_ALL.attribute4%TYPE;
2868: l_attribute5 AP_INVOICES_ALL.attribute5%TYPE;
2869: l_attribute6 AP_INVOICES_ALL.attribute6%TYPE;
2870: l_attribute7 AP_INVOICES_ALL.attribute7%TYPE;
2871: l_attribute8 AP_INVOICES_ALL.attribute8%TYPE;
2872: l_attribute9 AP_INVOICES_ALL.attribute9%TYPE;
2873: l_attribute10 AP_INVOICES_ALL.attribute10%TYPE;
2874: l_attribute11 AP_INVOICES_ALL.attribute11%TYPE;

Line 2871: l_attribute8 AP_INVOICES_ALL.attribute8%TYPE;

2867: l_attribute4 AP_INVOICES_ALL.attribute4%TYPE;
2868: l_attribute5 AP_INVOICES_ALL.attribute5%TYPE;
2869: l_attribute6 AP_INVOICES_ALL.attribute6%TYPE;
2870: l_attribute7 AP_INVOICES_ALL.attribute7%TYPE;
2871: l_attribute8 AP_INVOICES_ALL.attribute8%TYPE;
2872: l_attribute9 AP_INVOICES_ALL.attribute9%TYPE;
2873: l_attribute10 AP_INVOICES_ALL.attribute10%TYPE;
2874: l_attribute11 AP_INVOICES_ALL.attribute11%TYPE;
2875: l_attribute12 AP_INVOICES_ALL.attribute12%TYPE;

Line 2872: l_attribute9 AP_INVOICES_ALL.attribute9%TYPE;

2868: l_attribute5 AP_INVOICES_ALL.attribute5%TYPE;
2869: l_attribute6 AP_INVOICES_ALL.attribute6%TYPE;
2870: l_attribute7 AP_INVOICES_ALL.attribute7%TYPE;
2871: l_attribute8 AP_INVOICES_ALL.attribute8%TYPE;
2872: l_attribute9 AP_INVOICES_ALL.attribute9%TYPE;
2873: l_attribute10 AP_INVOICES_ALL.attribute10%TYPE;
2874: l_attribute11 AP_INVOICES_ALL.attribute11%TYPE;
2875: l_attribute12 AP_INVOICES_ALL.attribute12%TYPE;
2876: l_attribute13 AP_INVOICES_ALL.attribute13%TYPE;

Line 2873: l_attribute10 AP_INVOICES_ALL.attribute10%TYPE;

2869: l_attribute6 AP_INVOICES_ALL.attribute6%TYPE;
2870: l_attribute7 AP_INVOICES_ALL.attribute7%TYPE;
2871: l_attribute8 AP_INVOICES_ALL.attribute8%TYPE;
2872: l_attribute9 AP_INVOICES_ALL.attribute9%TYPE;
2873: l_attribute10 AP_INVOICES_ALL.attribute10%TYPE;
2874: l_attribute11 AP_INVOICES_ALL.attribute11%TYPE;
2875: l_attribute12 AP_INVOICES_ALL.attribute12%TYPE;
2876: l_attribute13 AP_INVOICES_ALL.attribute13%TYPE;
2877: l_attribute14 AP_INVOICES_ALL.attribute14%TYPE;

Line 2874: l_attribute11 AP_INVOICES_ALL.attribute11%TYPE;

2870: l_attribute7 AP_INVOICES_ALL.attribute7%TYPE;
2871: l_attribute8 AP_INVOICES_ALL.attribute8%TYPE;
2872: l_attribute9 AP_INVOICES_ALL.attribute9%TYPE;
2873: l_attribute10 AP_INVOICES_ALL.attribute10%TYPE;
2874: l_attribute11 AP_INVOICES_ALL.attribute11%TYPE;
2875: l_attribute12 AP_INVOICES_ALL.attribute12%TYPE;
2876: l_attribute13 AP_INVOICES_ALL.attribute13%TYPE;
2877: l_attribute14 AP_INVOICES_ALL.attribute14%TYPE;
2878: l_attribute15 AP_INVOICES_ALL.attribute15%TYPE;

Line 2875: l_attribute12 AP_INVOICES_ALL.attribute12%TYPE;

2871: l_attribute8 AP_INVOICES_ALL.attribute8%TYPE;
2872: l_attribute9 AP_INVOICES_ALL.attribute9%TYPE;
2873: l_attribute10 AP_INVOICES_ALL.attribute10%TYPE;
2874: l_attribute11 AP_INVOICES_ALL.attribute11%TYPE;
2875: l_attribute12 AP_INVOICES_ALL.attribute12%TYPE;
2876: l_attribute13 AP_INVOICES_ALL.attribute13%TYPE;
2877: l_attribute14 AP_INVOICES_ALL.attribute14%TYPE;
2878: l_attribute15 AP_INVOICES_ALL.attribute15%TYPE;
2879: li_attribute_category AP_INVOICES_ALL.attribute_category%TYPE;

Line 2876: l_attribute13 AP_INVOICES_ALL.attribute13%TYPE;

2872: l_attribute9 AP_INVOICES_ALL.attribute9%TYPE;
2873: l_attribute10 AP_INVOICES_ALL.attribute10%TYPE;
2874: l_attribute11 AP_INVOICES_ALL.attribute11%TYPE;
2875: l_attribute12 AP_INVOICES_ALL.attribute12%TYPE;
2876: l_attribute13 AP_INVOICES_ALL.attribute13%TYPE;
2877: l_attribute14 AP_INVOICES_ALL.attribute14%TYPE;
2878: l_attribute15 AP_INVOICES_ALL.attribute15%TYPE;
2879: li_attribute_category AP_INVOICES_ALL.attribute_category%TYPE;
2880: li_attribute1 AP_INVOICE_LINES_ALL.attribute1%TYPE;

Line 2877: l_attribute14 AP_INVOICES_ALL.attribute14%TYPE;

2873: l_attribute10 AP_INVOICES_ALL.attribute10%TYPE;
2874: l_attribute11 AP_INVOICES_ALL.attribute11%TYPE;
2875: l_attribute12 AP_INVOICES_ALL.attribute12%TYPE;
2876: l_attribute13 AP_INVOICES_ALL.attribute13%TYPE;
2877: l_attribute14 AP_INVOICES_ALL.attribute14%TYPE;
2878: l_attribute15 AP_INVOICES_ALL.attribute15%TYPE;
2879: li_attribute_category AP_INVOICES_ALL.attribute_category%TYPE;
2880: li_attribute1 AP_INVOICE_LINES_ALL.attribute1%TYPE;
2881: li_attribute2 AP_INVOICE_LINES_ALL.attribute2%TYPE;

Line 2878: l_attribute15 AP_INVOICES_ALL.attribute15%TYPE;

2874: l_attribute11 AP_INVOICES_ALL.attribute11%TYPE;
2875: l_attribute12 AP_INVOICES_ALL.attribute12%TYPE;
2876: l_attribute13 AP_INVOICES_ALL.attribute13%TYPE;
2877: l_attribute14 AP_INVOICES_ALL.attribute14%TYPE;
2878: l_attribute15 AP_INVOICES_ALL.attribute15%TYPE;
2879: li_attribute_category AP_INVOICES_ALL.attribute_category%TYPE;
2880: li_attribute1 AP_INVOICE_LINES_ALL.attribute1%TYPE;
2881: li_attribute2 AP_INVOICE_LINES_ALL.attribute2%TYPE;
2882: li_attribute3 AP_INVOICE_LINES_ALL.attribute3%TYPE;

Line 2879: li_attribute_category AP_INVOICES_ALL.attribute_category%TYPE;

2875: l_attribute12 AP_INVOICES_ALL.attribute12%TYPE;
2876: l_attribute13 AP_INVOICES_ALL.attribute13%TYPE;
2877: l_attribute14 AP_INVOICES_ALL.attribute14%TYPE;
2878: l_attribute15 AP_INVOICES_ALL.attribute15%TYPE;
2879: li_attribute_category AP_INVOICES_ALL.attribute_category%TYPE;
2880: li_attribute1 AP_INVOICE_LINES_ALL.attribute1%TYPE;
2881: li_attribute2 AP_INVOICE_LINES_ALL.attribute2%TYPE;
2882: li_attribute3 AP_INVOICE_LINES_ALL.attribute3%TYPE;
2883: li_attribute4 AP_INVOICE_LINES_ALL.attribute4%TYPE;