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_ISP_UTILITIES_PKG dependencies on AP_INVOICE_LINES_ALL

Line 348: FROM po_headers_all p, ap_invoice_lines_all l

344: END IF;
345: BEGIN
346: SELECT p.terms_id
347: INTO p_terms_id
348: FROM po_headers_all p, ap_invoice_lines_all l
349: WHERE p.type_lookup_code in ('BLANKET', 'PLANNED', 'STANDARD')
350: AND l.po_header_id = p.po_header_id
351: AND l.invoice_id = p_invoice_id
352: AND p.terms_id IS NOT NULL

Line 372: ap_invoice_lines_all l

368: SELECT p.terms_id
369: INTO p_terms_id
370: FROM rcv_shipment_lines r,
371: po_headers_all p,
372: ap_invoice_lines_all l
373: WHERE p.po_header_id = r.po_header_id
374: AND r.shipment_line_id = l.rcv_shipment_line_id
375: AND l.invoice_id = p_invoice_id
376: AND p.terms_id IS NOT NULL

Line 717: from ap_invoice_lines_all

713: l_line_rec.discarded_flag, l_line_rec.cancelled_flag,
714: l_line_rec.period_name,
715: l_line_rec.line_type_lookup_code,
716: l_line_rec.match_type
717: from ap_invoice_lines_all
718: where invoice_id = p_invoice_id
719: and line_number = p_line_number;
720:
721: l_debug_info := 'invoice_id = ' || l_line_rec.invoice_id ||

Line 1224: FROM ap_invoice_lines_all

1220: SUM(DECODE(line_type_lookup_code,'FREIGHT',NVL(amount, 0) - NVL(included_tax_amount, 0),0)) FREIGHT_SUM,
1221: sum(decode(line_type_lookup_code, 'ITEM', NVL(retained_amount, 0), 0)) RETAINAGE_SUM,
1222: count(*) /*Bug 14386893*/
1223: INTO l_item_sum, l_tax_sum, l_misc_sum, l_frt_sum, l_retained_sum, l_lines_cnt
1224: FROM ap_invoice_lines_all
1225: WHERE invoice_id = p_invoice_id;
1226:
1227:
1228: EXCEPTION

Line 1379: UPDATE ap_invoice_lines_all

1375: /* Bug 9768308 end */
1376: END IF;
1377:
1378: --Bug 5500186
1379: UPDATE ap_invoice_lines_all
1380: SET requester_id = l_requester_id
1381: WHERE line_type_lookup_code = 'ITEM'
1382: AND requester_id is NULL
1383: AND invoice_id = p_invoice_id;

Line 1588: l_period_name ap_invoice_lines_all.period_name%TYPE;

1584:
1585: l_wfitemkey VARCHAR2(50);
1586: l_dist_set_id ap_supplier_sites_all.distribution_set_id%TYPE;
1587: -- Bug 6859035
1588: l_period_name ap_invoice_lines_all.period_name%TYPE;
1589: l_gl_date ap_invoice_lines_all.accounting_date%TYPE;
1590: l_org_id ap_invoices_all.org_id%TYPE;
1591:
1592: -- Bug 7706967 : Start

Line 1589: l_gl_date ap_invoice_lines_all.accounting_date%TYPE;

1585: l_wfitemkey VARCHAR2(50);
1586: l_dist_set_id ap_supplier_sites_all.distribution_set_id%TYPE;
1587: -- Bug 6859035
1588: l_period_name ap_invoice_lines_all.period_name%TYPE;
1589: l_gl_date ap_invoice_lines_all.accounting_date%TYPE;
1590: l_org_id ap_invoices_all.org_id%TYPE;
1591:
1592: -- Bug 7706967 : Start
1593: l_vendor_name ap_suppliers.vendor_name%TYPE;

Line 1609: l_type_1099 ap_invoice_lines_all.type_1099%TYPE;

1605: l_exclude_freight_from_disc VARCHAR2(1) :='N';
1606: l_exclude_tax_from_disc VARCHAR2(1) :='N';
1607:
1608: -- Bug 9531531
1609: l_type_1099 ap_invoice_lines_all.type_1099%TYPE;
1610: -- Bug 10040759
1611: l_type_1099_po ap_invoice_lines_all.type_1099%TYPE;
1612: l_log_msg VARCHAR2(1000);
1613: l_lines_cnt NUMBER; /*Bug 14386893*/

Line 1611: l_type_1099_po ap_invoice_lines_all.type_1099%TYPE;

1607:
1608: -- Bug 9531531
1609: l_type_1099 ap_invoice_lines_all.type_1099%TYPE;
1610: -- Bug 10040759
1611: l_type_1099_po ap_invoice_lines_all.type_1099%TYPE;
1612: l_log_msg VARCHAR2(1000);
1613: l_lines_cnt NUMBER; /*Bug 14386893*/
1614: NULL_EXCHG_RATE EXCEPTION;
1615:

Line 1708: FOR line in (SELECT * from ap_invoice_lines_all where invoice_id = p_invoice_id)

1704: END IF;
1705: -- Bug 9531531 End
1706:
1707: -- Bug 10040759 Begin
1708: FOR line in (SELECT * from ap_invoice_lines_all where invoice_id = p_invoice_id)
1709: LOOP
1710: BEGIN
1711: SELECT type_1099
1712: INTO l_type_1099_po

Line 1719: UPDATE ap_invoice_lines_all

1715: AND rownum = 1;
1716: EXCEPTION
1717: WHEN NO_DATA_FOUND THEN NULL;
1718: END;
1719: UPDATE ap_invoice_lines_all
1720: SET type_1099 = NVL(l_type_1099_po, l_type_1099)
1721: WHERE invoice_id = line.invoice_id
1722: AND line_number = line.line_number;
1723: END LOOP;

Line 1726: UPDATE ap_invoice_lines_all

1722: AND line_number = line.line_number;
1723: END LOOP;
1724: -- Bug 10040759 End
1725:
1726: UPDATE ap_invoice_lines_all
1727: SET accounting_date = l_gl_date,
1728: period_name = l_period_name
1729: --type_1099 = l_type_1099 -- Bug 9531531
1730: WHERE invoice_id = p_invoice_id ;

Line 1755: FROM ap_invoice_lines_all

1751: SUM(DECODE(line_type_lookup_code,'FREIGHT',NVL(amount, 0) - NVL(included_tax_amount, 0),0)) FREIGHT_SUM,
1752: sum(decode(line_type_lookup_code, 'ITEM', NVL(retained_amount, 0), 0)) RETAINAGE_SUM,
1753: count(*) /*Bug 14386893*/
1754: INTO l_item_sum, l_tax_sum, l_misc_sum, l_frt_sum, l_retained_sum, l_lines_cnt
1755: FROM ap_invoice_lines_all
1756: WHERE invoice_id = p_invoice_id;
1757: EXCEPTION
1758: WHEN NO_DATA_FOUND THEN
1759: l_debug_info := 'no lines found for the invoice id = '|| p_invoice_id;

Line 2001: FROM ap_invoice_lines_all

1997: P_Calling_Sequence IN VARCHAR2) IS
1998:
1999: CURSOR Invoice_Lines_cur IS
2000: SELECT line_number, quantity_invoiced, amount, po_line_location_id
2001: FROM ap_invoice_lines_all
2002: WHERE invoice_id = P_invoice_id
2003: AND NVL(discarded_flag, 'N' ) <> 'Y'
2004: AND nvl(generate_dists,'Y') <> 'D' --5090119
2005: AND line_type_lookup_code = 'ITEM';

Line 2007: l_invoice_line_number ap_invoice_lines_all.line_number%TYPE;

2003: AND NVL(discarded_flag, 'N' ) <> 'Y'
2004: AND nvl(generate_dists,'Y') <> 'D' --5090119
2005: AND line_type_lookup_code = 'ITEM';
2006:
2007: l_invoice_line_number ap_invoice_lines_all.line_number%TYPE;
2008: l_po_line_location_id ap_invoice_lines_all.po_line_location_id%TYPE;
2009: l_quantity ap_invoice_lines_all.quantity_invoiced%TYPE;
2010: l_amount ap_invoice_lines_all.amount%TYPE;
2011: l_billed ap_invoice_lines_all.amount%TYPE;

Line 2008: l_po_line_location_id ap_invoice_lines_all.po_line_location_id%TYPE;

2004: AND nvl(generate_dists,'Y') <> 'D' --5090119
2005: AND line_type_lookup_code = 'ITEM';
2006:
2007: l_invoice_line_number ap_invoice_lines_all.line_number%TYPE;
2008: l_po_line_location_id ap_invoice_lines_all.po_line_location_id%TYPE;
2009: l_quantity ap_invoice_lines_all.quantity_invoiced%TYPE;
2010: l_amount ap_invoice_lines_all.amount%TYPE;
2011: l_billed ap_invoice_lines_all.amount%TYPE;
2012: l_quantity_ordered ap_invoice_lines_all.amount%TYPE;

Line 2009: l_quantity ap_invoice_lines_all.quantity_invoiced%TYPE;

2005: AND line_type_lookup_code = 'ITEM';
2006:
2007: l_invoice_line_number ap_invoice_lines_all.line_number%TYPE;
2008: l_po_line_location_id ap_invoice_lines_all.po_line_location_id%TYPE;
2009: l_quantity ap_invoice_lines_all.quantity_invoiced%TYPE;
2010: l_amount ap_invoice_lines_all.amount%TYPE;
2011: l_billed ap_invoice_lines_all.amount%TYPE;
2012: l_quantity_ordered ap_invoice_lines_all.amount%TYPE;
2013: l_amount_ordered ap_invoice_lines_all.amount%TYPE;

Line 2010: l_amount ap_invoice_lines_all.amount%TYPE;

2006:
2007: l_invoice_line_number ap_invoice_lines_all.line_number%TYPE;
2008: l_po_line_location_id ap_invoice_lines_all.po_line_location_id%TYPE;
2009: l_quantity ap_invoice_lines_all.quantity_invoiced%TYPE;
2010: l_amount ap_invoice_lines_all.amount%TYPE;
2011: l_billed ap_invoice_lines_all.amount%TYPE;
2012: l_quantity_ordered ap_invoice_lines_all.amount%TYPE;
2013: l_amount_ordered ap_invoice_lines_all.amount%TYPE;
2014: l_matching_basis po_line_locations_all.matching_basis%TYPE;

Line 2011: l_billed ap_invoice_lines_all.amount%TYPE;

2007: l_invoice_line_number ap_invoice_lines_all.line_number%TYPE;
2008: l_po_line_location_id ap_invoice_lines_all.po_line_location_id%TYPE;
2009: l_quantity ap_invoice_lines_all.quantity_invoiced%TYPE;
2010: l_amount ap_invoice_lines_all.amount%TYPE;
2011: l_billed ap_invoice_lines_all.amount%TYPE;
2012: l_quantity_ordered ap_invoice_lines_all.amount%TYPE;
2013: l_amount_ordered ap_invoice_lines_all.amount%TYPE;
2014: l_matching_basis po_line_locations_all.matching_basis%TYPE;
2015: l_overbill_flag VARCHAR2(2);

Line 2012: l_quantity_ordered ap_invoice_lines_all.amount%TYPE;

2008: l_po_line_location_id ap_invoice_lines_all.po_line_location_id%TYPE;
2009: l_quantity ap_invoice_lines_all.quantity_invoiced%TYPE;
2010: l_amount ap_invoice_lines_all.amount%TYPE;
2011: l_billed ap_invoice_lines_all.amount%TYPE;
2012: l_quantity_ordered ap_invoice_lines_all.amount%TYPE;
2013: l_amount_ordered ap_invoice_lines_all.amount%TYPE;
2014: l_matching_basis po_line_locations_all.matching_basis%TYPE;
2015: l_overbill_flag VARCHAR2(2);
2016: l_curr_calling_sequence VARCHAR2(2000);

Line 2013: l_amount_ordered ap_invoice_lines_all.amount%TYPE;

2009: l_quantity ap_invoice_lines_all.quantity_invoiced%TYPE;
2010: l_amount ap_invoice_lines_all.amount%TYPE;
2011: l_billed ap_invoice_lines_all.amount%TYPE;
2012: l_quantity_ordered ap_invoice_lines_all.amount%TYPE;
2013: l_amount_ordered ap_invoice_lines_all.amount%TYPE;
2014: l_matching_basis po_line_locations_all.matching_basis%TYPE;
2015: l_overbill_flag VARCHAR2(2);
2016: l_curr_calling_sequence VARCHAR2(2000);
2017: l_debug_info VARCHAR2(2000);

Line 2524: from ap_invoice_lines_all

2520: begin
2521:
2522: select *
2523: into l_line_rec
2524: from ap_invoice_lines_all
2525: where invoice_id = p_invoice_id
2526: and line_number = p_line_number;
2527:
2528:

Line 2545: from ap_invoice_lines_all

2541:
2542:
2543: select max(line_number)+1
2544: into l_line_rec.line_number
2545: from ap_invoice_lines_all
2546: where invoice_id = p_invoice_id;
2547:
2548: INSERT INTO AP_INVOICE_LINES (
2549: INVOICE_ID,

Line 2941: FROM ap_invoice_lines_all

2937: BEGIN
2938: --
2939: SELECT COUNT(*)
2940: INTO l_count
2941: FROM ap_invoice_lines_all
2942: WHERE po_header_id IS NOT NULL
2943: AND invoice_id = p_invoice_id;
2944:
2945: IF l_count = 0 THEN

Line 2952: FROM ap_invoice_lines_All

2948: SELECT count(*)
2949: INTO l_po_count
2950: FROM po_headers_all
2951: WHERE po_header_id IN (SELECT po_header_id
2952: FROM ap_invoice_lines_All
2953: WHERE invoice_id = p_invoice_id);
2954:
2955: IF l_po_count = 1 THEN
2956: --

Line 2961: FROM ap_invoice_lines_All

2957: SELECT COUNT(*)
2958: INTO l_release_count
2959: FROM po_releases_all pr
2960: WHERE po_header_id IN (SELECT po_header_id
2961: FROM ap_invoice_lines_All
2962: WHERE invoice_id = p_invoice_id);
2963: --
2964: IF (l_release_count = 0 OR l_release_count = 1) THEN
2965: RETURN 'SINGLE';

Line 2999: FROM ap_invoice_lines_All

2995: INTO l_po_number,
2996: l_po_header_id
2997: FROM po_headers_all POH
2998: WHERE po_header_id IN ( SELECT po_header_id
2999: FROM ap_invoice_lines_All
3000: WHERE invoice_id = p_invoice_id);
3001:
3002: SELECT COUNT(*)
3003: INTO l_release_count

Line 3036: FROM ap_invoice_lines_all

3032: BEGIN
3033: --
3034: SELECT COUNT(*)
3035: INTO l_count
3036: FROM ap_invoice_lines_all
3037: WHERE po_header_id IS NOT NULL
3038: AND invoice_id = p_invoice_id;
3039:
3040: IF l_count <> 0 THEN

Line 3046: FROM ap_invoice_lines_All

3042: SELECT count(*)
3043: INTO l_po_count
3044: FROM po_headers_all
3045: WHERE po_header_id IN (SELECT po_header_id
3046: FROM ap_invoice_lines_All
3047: WHERE invoice_id = p_invoice_id);
3048:
3049: IF l_po_count = 1 THEN
3050: SELECT po_header_id

Line 3054: FROM ap_invoice_lines_All

3050: SELECT po_header_id
3051: INTO l_po_header_id
3052: FROM po_headers_all POH
3053: WHERE po_header_id IN ( SELECT po_header_id
3054: FROM ap_invoice_lines_All
3055: WHERE invoice_id = p_invoice_id);
3056: END IF;
3057: END IF;
3058: --

Line 3083: FROM ap_invoice_lines_All

3079: SELECT COUNT(*)
3080: INTO l_release_count
3081: FROM po_releases_all pr
3082: WHERE po_header_id IN (SELECT po_header_id
3083: FROM ap_invoice_lines_All
3084: WHERE invoice_id = p_invoice_id);
3085: --
3086: IF l_release_count = 1 THEN
3087: --