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_LINES_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 2190: FROM ap_invoice_lines_all AIL

2186: l_net_inv_amount NUMBER := 0;
2187: BEGIN
2188: SELECT nvl((0 - sum(AIL.amount)),0)
2189: INTO l_prepay_amount
2190: FROM ap_invoice_lines_all AIL
2191: WHERE AIL.invoice_id = p_invoice_id
2192: AND nvl(AIL.invoice_includes_prepay_flag,'N') = 'N'
2193: AND (AIL.line_type_lookup_code = 'PREPAY'
2194: OR (AIL.line_type_lookup_code = 'TAX'

Line 2889: li_attribute1 AP_INVOICE_LINES_ALL.attribute1%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;
2893: li_attribute5 AP_INVOICE_LINES_ALL.attribute5%TYPE;

Line 2890: li_attribute2 AP_INVOICE_LINES_ALL.attribute2%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;
2893: li_attribute5 AP_INVOICE_LINES_ALL.attribute5%TYPE;
2894: li_attribute6 AP_INVOICE_LINES_ALL.attribute6%TYPE;

Line 2891: li_attribute3 AP_INVOICE_LINES_ALL.attribute3%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;
2893: li_attribute5 AP_INVOICE_LINES_ALL.attribute5%TYPE;
2894: li_attribute6 AP_INVOICE_LINES_ALL.attribute6%TYPE;
2895: li_attribute7 AP_INVOICE_LINES_ALL.attribute7%TYPE;

Line 2892: li_attribute4 AP_INVOICE_LINES_ALL.attribute4%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;
2893: li_attribute5 AP_INVOICE_LINES_ALL.attribute5%TYPE;
2894: li_attribute6 AP_INVOICE_LINES_ALL.attribute6%TYPE;
2895: li_attribute7 AP_INVOICE_LINES_ALL.attribute7%TYPE;
2896: li_attribute8 AP_INVOICE_LINES_ALL.attribute8%TYPE;

Line 2893: li_attribute5 AP_INVOICE_LINES_ALL.attribute5%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;
2893: li_attribute5 AP_INVOICE_LINES_ALL.attribute5%TYPE;
2894: li_attribute6 AP_INVOICE_LINES_ALL.attribute6%TYPE;
2895: li_attribute7 AP_INVOICE_LINES_ALL.attribute7%TYPE;
2896: li_attribute8 AP_INVOICE_LINES_ALL.attribute8%TYPE;
2897: li_attribute9 AP_INVOICE_LINES_ALL.attribute9%TYPE;

Line 2894: li_attribute6 AP_INVOICE_LINES_ALL.attribute6%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;
2893: li_attribute5 AP_INVOICE_LINES_ALL.attribute5%TYPE;
2894: li_attribute6 AP_INVOICE_LINES_ALL.attribute6%TYPE;
2895: li_attribute7 AP_INVOICE_LINES_ALL.attribute7%TYPE;
2896: li_attribute8 AP_INVOICE_LINES_ALL.attribute8%TYPE;
2897: li_attribute9 AP_INVOICE_LINES_ALL.attribute9%TYPE;
2898: li_attribute10 AP_INVOICE_LINES_ALL.attribute10%TYPE;

Line 2895: li_attribute7 AP_INVOICE_LINES_ALL.attribute7%TYPE;

2891: li_attribute3 AP_INVOICE_LINES_ALL.attribute3%TYPE;
2892: li_attribute4 AP_INVOICE_LINES_ALL.attribute4%TYPE;
2893: li_attribute5 AP_INVOICE_LINES_ALL.attribute5%TYPE;
2894: li_attribute6 AP_INVOICE_LINES_ALL.attribute6%TYPE;
2895: li_attribute7 AP_INVOICE_LINES_ALL.attribute7%TYPE;
2896: li_attribute8 AP_INVOICE_LINES_ALL.attribute8%TYPE;
2897: li_attribute9 AP_INVOICE_LINES_ALL.attribute9%TYPE;
2898: li_attribute10 AP_INVOICE_LINES_ALL.attribute10%TYPE;
2899: li_attribute11 AP_INVOICE_LINES_ALL.attribute11%TYPE;

Line 2896: li_attribute8 AP_INVOICE_LINES_ALL.attribute8%TYPE;

2892: li_attribute4 AP_INVOICE_LINES_ALL.attribute4%TYPE;
2893: li_attribute5 AP_INVOICE_LINES_ALL.attribute5%TYPE;
2894: li_attribute6 AP_INVOICE_LINES_ALL.attribute6%TYPE;
2895: li_attribute7 AP_INVOICE_LINES_ALL.attribute7%TYPE;
2896: li_attribute8 AP_INVOICE_LINES_ALL.attribute8%TYPE;
2897: li_attribute9 AP_INVOICE_LINES_ALL.attribute9%TYPE;
2898: li_attribute10 AP_INVOICE_LINES_ALL.attribute10%TYPE;
2899: li_attribute11 AP_INVOICE_LINES_ALL.attribute11%TYPE;
2900: li_attribute12 AP_INVOICE_LINES_ALL.attribute12%TYPE;

Line 2897: li_attribute9 AP_INVOICE_LINES_ALL.attribute9%TYPE;

2893: li_attribute5 AP_INVOICE_LINES_ALL.attribute5%TYPE;
2894: li_attribute6 AP_INVOICE_LINES_ALL.attribute6%TYPE;
2895: li_attribute7 AP_INVOICE_LINES_ALL.attribute7%TYPE;
2896: li_attribute8 AP_INVOICE_LINES_ALL.attribute8%TYPE;
2897: li_attribute9 AP_INVOICE_LINES_ALL.attribute9%TYPE;
2898: li_attribute10 AP_INVOICE_LINES_ALL.attribute10%TYPE;
2899: li_attribute11 AP_INVOICE_LINES_ALL.attribute11%TYPE;
2900: li_attribute12 AP_INVOICE_LINES_ALL.attribute12%TYPE;
2901: li_attribute13 AP_INVOICE_LINES_ALL.attribute13%TYPE;

Line 2898: li_attribute10 AP_INVOICE_LINES_ALL.attribute10%TYPE;

2894: li_attribute6 AP_INVOICE_LINES_ALL.attribute6%TYPE;
2895: li_attribute7 AP_INVOICE_LINES_ALL.attribute7%TYPE;
2896: li_attribute8 AP_INVOICE_LINES_ALL.attribute8%TYPE;
2897: li_attribute9 AP_INVOICE_LINES_ALL.attribute9%TYPE;
2898: li_attribute10 AP_INVOICE_LINES_ALL.attribute10%TYPE;
2899: li_attribute11 AP_INVOICE_LINES_ALL.attribute11%TYPE;
2900: li_attribute12 AP_INVOICE_LINES_ALL.attribute12%TYPE;
2901: li_attribute13 AP_INVOICE_LINES_ALL.attribute13%TYPE;
2902: li_attribute14 AP_INVOICE_LINES_ALL.attribute14%TYPE;

Line 2899: li_attribute11 AP_INVOICE_LINES_ALL.attribute11%TYPE;

2895: li_attribute7 AP_INVOICE_LINES_ALL.attribute7%TYPE;
2896: li_attribute8 AP_INVOICE_LINES_ALL.attribute8%TYPE;
2897: li_attribute9 AP_INVOICE_LINES_ALL.attribute9%TYPE;
2898: li_attribute10 AP_INVOICE_LINES_ALL.attribute10%TYPE;
2899: li_attribute11 AP_INVOICE_LINES_ALL.attribute11%TYPE;
2900: li_attribute12 AP_INVOICE_LINES_ALL.attribute12%TYPE;
2901: li_attribute13 AP_INVOICE_LINES_ALL.attribute13%TYPE;
2902: li_attribute14 AP_INVOICE_LINES_ALL.attribute14%TYPE;
2903: li_attribute15 AP_INVOICE_LINES_ALL.attribute15%TYPE;

Line 2900: li_attribute12 AP_INVOICE_LINES_ALL.attribute12%TYPE;

2896: li_attribute8 AP_INVOICE_LINES_ALL.attribute8%TYPE;
2897: li_attribute9 AP_INVOICE_LINES_ALL.attribute9%TYPE;
2898: li_attribute10 AP_INVOICE_LINES_ALL.attribute10%TYPE;
2899: li_attribute11 AP_INVOICE_LINES_ALL.attribute11%TYPE;
2900: li_attribute12 AP_INVOICE_LINES_ALL.attribute12%TYPE;
2901: li_attribute13 AP_INVOICE_LINES_ALL.attribute13%TYPE;
2902: li_attribute14 AP_INVOICE_LINES_ALL.attribute14%TYPE;
2903: li_attribute15 AP_INVOICE_LINES_ALL.attribute15%TYPE;
2904:

Line 2901: li_attribute13 AP_INVOICE_LINES_ALL.attribute13%TYPE;

2897: li_attribute9 AP_INVOICE_LINES_ALL.attribute9%TYPE;
2898: li_attribute10 AP_INVOICE_LINES_ALL.attribute10%TYPE;
2899: li_attribute11 AP_INVOICE_LINES_ALL.attribute11%TYPE;
2900: li_attribute12 AP_INVOICE_LINES_ALL.attribute12%TYPE;
2901: li_attribute13 AP_INVOICE_LINES_ALL.attribute13%TYPE;
2902: li_attribute14 AP_INVOICE_LINES_ALL.attribute14%TYPE;
2903: li_attribute15 AP_INVOICE_LINES_ALL.attribute15%TYPE;
2904:
2905: BEGIN

Line 2902: li_attribute14 AP_INVOICE_LINES_ALL.attribute14%TYPE;

2898: li_attribute10 AP_INVOICE_LINES_ALL.attribute10%TYPE;
2899: li_attribute11 AP_INVOICE_LINES_ALL.attribute11%TYPE;
2900: li_attribute12 AP_INVOICE_LINES_ALL.attribute12%TYPE;
2901: li_attribute13 AP_INVOICE_LINES_ALL.attribute13%TYPE;
2902: li_attribute14 AP_INVOICE_LINES_ALL.attribute14%TYPE;
2903: li_attribute15 AP_INVOICE_LINES_ALL.attribute15%TYPE;
2904:
2905: BEGIN
2906:

Line 2903: li_attribute15 AP_INVOICE_LINES_ALL.attribute15%TYPE;

2899: li_attribute11 AP_INVOICE_LINES_ALL.attribute11%TYPE;
2900: li_attribute12 AP_INVOICE_LINES_ALL.attribute12%TYPE;
2901: li_attribute13 AP_INVOICE_LINES_ALL.attribute13%TYPE;
2902: li_attribute14 AP_INVOICE_LINES_ALL.attribute14%TYPE;
2903: li_attribute15 AP_INVOICE_LINES_ALL.attribute15%TYPE;
2904:
2905: BEGIN
2906:
2907: -- Update the calling sequence