DBA Data[Home] [Help]

APPS.AP_ISP_UTILITIES_PKG dependencies on AP_INVOICE_LINES_ALL

Line 344: FROM po_headers_all p, ap_invoice_lines_all l

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

Line 368: ap_invoice_lines_all l

364: SELECT p.terms_id
365: INTO p_terms_id
366: FROM rcv_shipment_lines r,
367: po_headers_all p,
368: ap_invoice_lines_all l
369: WHERE p.po_header_id = r.po_header_id
370: AND r.shipment_line_id = l.rcv_shipment_line_id
371: AND l.invoice_id = p_invoice_id
372: AND p.terms_id IS NOT NULL

Line 713: from ap_invoice_lines_all

709: l_line_rec.discarded_flag, l_line_rec.cancelled_flag,
710: l_line_rec.period_name,
711: l_line_rec.line_type_lookup_code,
712: l_line_rec.match_type
713: from ap_invoice_lines_all
714: where invoice_id = p_invoice_id
715: and line_number = p_line_number;
716:
717: l_debug_info := 'invoice_id = ' || l_line_rec.invoice_id ||

Line 1204: FROM ap_invoice_lines_all

1200: SUM(DECODE(line_type_lookup_code,'MISCELLANEOUS',NVL(amount, 0) - NVL(included_tax_amount, 0),0)) MISC_SUM, --Bug
1201: SUM(DECODE(line_type_lookup_code,'FREIGHT',NVL(amount, 0) - NVL(included_tax_amount, 0),0)) FREIGHT_SUM,
1202: sum(decode(line_type_lookup_code, 'ITEM', NVL(retained_amount, 0), 0)) RETAINAGE_SUM
1203: INTO l_item_sum, l_tax_sum, l_misc_sum, l_frt_sum, l_retained_sum
1204: FROM ap_invoice_lines_all
1205: WHERE invoice_id = p_invoice_id;
1206:
1207: EXCEPTION
1208: WHEN NO_DATA_FOUND THEN

Line 1297: UPDATE ap_invoice_lines_all

1293: WHERE invoice_id = p_invoice_id;
1294: END IF;
1295:
1296: --Bug 5500186
1297: UPDATE ap_invoice_lines_all
1298: SET requester_id = l_requester_id
1299: WHERE line_type_lookup_code = 'ITEM'
1300: AND requester_id is NULL
1301: AND invoice_id = p_invoice_id;

Line 1497: l_period_name ap_invoice_lines_all.period_name%TYPE;

1493:
1494: l_wfitemkey VARCHAR2(50);
1495: l_dist_set_id ap_supplier_sites_all.distribution_set_id%TYPE;
1496: -- Bug 6859035
1497: l_period_name ap_invoice_lines_all.period_name%TYPE;
1498: l_gl_date ap_invoice_lines_all.accounting_date%TYPE;
1499: l_org_id ap_invoices_all.org_id%TYPE;
1500:
1501: -- Bug 7706967 : Start

Line 1498: l_gl_date ap_invoice_lines_all.accounting_date%TYPE;

1494: l_wfitemkey VARCHAR2(50);
1495: l_dist_set_id ap_supplier_sites_all.distribution_set_id%TYPE;
1496: -- Bug 6859035
1497: l_period_name ap_invoice_lines_all.period_name%TYPE;
1498: l_gl_date ap_invoice_lines_all.accounting_date%TYPE;
1499: l_org_id ap_invoices_all.org_id%TYPE;
1500:
1501: -- Bug 7706967 : Start
1502: l_vendor_name ap_suppliers.vendor_name%TYPE;

Line 1580: UPDATE ap_invoice_lines_all

1576: relationship_id = -1
1577: WHERE invoice_id = p_invoice_id;
1578: -- Bug 7706967 - End
1579:
1580: UPDATE ap_invoice_lines_all
1581: SET accounting_date = l_gl_date,
1582: period_name = l_period_name
1583: WHERE invoice_id = p_invoice_id ;
1584:

Line 1607: FROM ap_invoice_lines_all

1603: SUM(DECODE(line_type_lookup_code,'MISCELLANEOUS',NVL(amount, 0) - NVL(included_tax_amount, 0),0)) MISC_SUM, --Bug
1604: SUM(DECODE(line_type_lookup_code,'FREIGHT',NVL(amount, 0) - NVL(included_tax_amount, 0),0)) FREIGHT_SUM,
1605: sum(decode(line_type_lookup_code, 'ITEM', NVL(retained_amount, 0), 0)) RETAINAGE_SUM
1606: INTO l_item_sum, l_tax_sum, l_misc_sum, l_frt_sum, l_retained_sum
1607: FROM ap_invoice_lines_all
1608: WHERE invoice_id = p_invoice_id;
1609:
1610: EXCEPTION
1611: WHEN NO_DATA_FOUND THEN

Line 1709: FROM ap_invoice_lines_all

1705: P_Calling_Sequence IN VARCHAR2) IS
1706:
1707: CURSOR Invoice_Lines_cur IS
1708: SELECT line_number, quantity_invoiced, amount, po_line_location_id
1709: FROM ap_invoice_lines_all
1710: WHERE invoice_id = P_invoice_id
1711: AND NVL(discarded_flag, 'N' ) <> 'Y'
1712: AND nvl(generate_dists,'Y') <> 'D' --5090119
1713: AND line_type_lookup_code = 'ITEM';

Line 1715: l_invoice_line_number ap_invoice_lines_all.line_number%TYPE;

1711: AND NVL(discarded_flag, 'N' ) <> 'Y'
1712: AND nvl(generate_dists,'Y') <> 'D' --5090119
1713: AND line_type_lookup_code = 'ITEM';
1714:
1715: l_invoice_line_number ap_invoice_lines_all.line_number%TYPE;
1716: l_po_line_location_id ap_invoice_lines_all.po_line_location_id%TYPE;
1717: l_quantity ap_invoice_lines_all.quantity_invoiced%TYPE;
1718: l_amount ap_invoice_lines_all.amount%TYPE;
1719: l_billed ap_invoice_lines_all.amount%TYPE;

Line 1716: l_po_line_location_id ap_invoice_lines_all.po_line_location_id%TYPE;

1712: AND nvl(generate_dists,'Y') <> 'D' --5090119
1713: AND line_type_lookup_code = 'ITEM';
1714:
1715: l_invoice_line_number ap_invoice_lines_all.line_number%TYPE;
1716: l_po_line_location_id ap_invoice_lines_all.po_line_location_id%TYPE;
1717: l_quantity ap_invoice_lines_all.quantity_invoiced%TYPE;
1718: l_amount ap_invoice_lines_all.amount%TYPE;
1719: l_billed ap_invoice_lines_all.amount%TYPE;
1720: l_quantity_ordered ap_invoice_lines_all.amount%TYPE;

Line 1717: l_quantity ap_invoice_lines_all.quantity_invoiced%TYPE;

1713: AND line_type_lookup_code = 'ITEM';
1714:
1715: l_invoice_line_number ap_invoice_lines_all.line_number%TYPE;
1716: l_po_line_location_id ap_invoice_lines_all.po_line_location_id%TYPE;
1717: l_quantity ap_invoice_lines_all.quantity_invoiced%TYPE;
1718: l_amount ap_invoice_lines_all.amount%TYPE;
1719: l_billed ap_invoice_lines_all.amount%TYPE;
1720: l_quantity_ordered ap_invoice_lines_all.amount%TYPE;
1721: l_amount_ordered ap_invoice_lines_all.amount%TYPE;

Line 1718: l_amount ap_invoice_lines_all.amount%TYPE;

1714:
1715: l_invoice_line_number ap_invoice_lines_all.line_number%TYPE;
1716: l_po_line_location_id ap_invoice_lines_all.po_line_location_id%TYPE;
1717: l_quantity ap_invoice_lines_all.quantity_invoiced%TYPE;
1718: l_amount ap_invoice_lines_all.amount%TYPE;
1719: l_billed ap_invoice_lines_all.amount%TYPE;
1720: l_quantity_ordered ap_invoice_lines_all.amount%TYPE;
1721: l_amount_ordered ap_invoice_lines_all.amount%TYPE;
1722: l_matching_basis po_line_locations_all.matching_basis%TYPE;

Line 1719: l_billed ap_invoice_lines_all.amount%TYPE;

1715: l_invoice_line_number ap_invoice_lines_all.line_number%TYPE;
1716: l_po_line_location_id ap_invoice_lines_all.po_line_location_id%TYPE;
1717: l_quantity ap_invoice_lines_all.quantity_invoiced%TYPE;
1718: l_amount ap_invoice_lines_all.amount%TYPE;
1719: l_billed ap_invoice_lines_all.amount%TYPE;
1720: l_quantity_ordered ap_invoice_lines_all.amount%TYPE;
1721: l_amount_ordered ap_invoice_lines_all.amount%TYPE;
1722: l_matching_basis po_line_locations_all.matching_basis%TYPE;
1723: l_overbill_flag VARCHAR2(2);

Line 1720: l_quantity_ordered ap_invoice_lines_all.amount%TYPE;

1716: l_po_line_location_id ap_invoice_lines_all.po_line_location_id%TYPE;
1717: l_quantity ap_invoice_lines_all.quantity_invoiced%TYPE;
1718: l_amount ap_invoice_lines_all.amount%TYPE;
1719: l_billed ap_invoice_lines_all.amount%TYPE;
1720: l_quantity_ordered ap_invoice_lines_all.amount%TYPE;
1721: l_amount_ordered ap_invoice_lines_all.amount%TYPE;
1722: l_matching_basis po_line_locations_all.matching_basis%TYPE;
1723: l_overbill_flag VARCHAR2(2);
1724: l_curr_calling_sequence VARCHAR2(2000);

Line 1721: l_amount_ordered ap_invoice_lines_all.amount%TYPE;

1717: l_quantity ap_invoice_lines_all.quantity_invoiced%TYPE;
1718: l_amount ap_invoice_lines_all.amount%TYPE;
1719: l_billed ap_invoice_lines_all.amount%TYPE;
1720: l_quantity_ordered ap_invoice_lines_all.amount%TYPE;
1721: l_amount_ordered ap_invoice_lines_all.amount%TYPE;
1722: l_matching_basis po_line_locations_all.matching_basis%TYPE;
1723: l_overbill_flag VARCHAR2(2);
1724: l_curr_calling_sequence VARCHAR2(2000);
1725: l_debug_info VARCHAR2(2000);

Line 2222: from ap_invoice_lines_all

2218: begin
2219:
2220: select *
2221: into l_line_rec
2222: from ap_invoice_lines_all
2223: where invoice_id = p_invoice_id
2224: and line_number = p_line_number;
2225:
2226:

Line 2243: from ap_invoice_lines_all

2239:
2240:
2241: select max(line_number)+1
2242: into l_line_rec.line_number
2243: from ap_invoice_lines_all
2244: where invoice_id = p_invoice_id;
2245:
2246: INSERT INTO AP_INVOICE_LINES (
2247: INVOICE_ID,

Line 2580: FROM ap_invoice_lines_all

2576: BEGIN
2577: --
2578: SELECT COUNT(*)
2579: INTO l_count
2580: FROM ap_invoice_lines_all
2581: WHERE po_header_id IS NOT NULL
2582: AND invoice_id = p_invoice_id;
2583:
2584: IF l_count = 0 THEN

Line 2591: FROM ap_invoice_lines_All

2587: SELECT count(*)
2588: INTO l_po_count
2589: FROM po_headers_all
2590: WHERE po_header_id IN (SELECT po_header_id
2591: FROM ap_invoice_lines_All
2592: WHERE invoice_id = p_invoice_id);
2593:
2594: IF l_po_count = 1 THEN
2595: --

Line 2600: FROM ap_invoice_lines_All

2596: SELECT COUNT(*)
2597: INTO l_release_count
2598: FROM po_releases_all pr
2599: WHERE po_header_id IN (SELECT po_header_id
2600: FROM ap_invoice_lines_All
2601: WHERE invoice_id = p_invoice_id);
2602: --
2603: IF (l_release_count = 0 OR l_release_count = 1) THEN
2604: RETURN 'SINGLE';

Line 2638: FROM ap_invoice_lines_All

2634: INTO l_po_number,
2635: l_po_header_id
2636: FROM po_headers_all POH
2637: WHERE po_header_id IN ( SELECT po_header_id
2638: FROM ap_invoice_lines_All
2639: WHERE invoice_id = p_invoice_id);
2640:
2641: SELECT COUNT(*)
2642: INTO l_release_count

Line 2675: FROM ap_invoice_lines_all

2671: BEGIN
2672: --
2673: SELECT COUNT(*)
2674: INTO l_count
2675: FROM ap_invoice_lines_all
2676: WHERE po_header_id IS NOT NULL
2677: AND invoice_id = p_invoice_id;
2678:
2679: IF l_count <> 0 THEN

Line 2685: FROM ap_invoice_lines_All

2681: SELECT count(*)
2682: INTO l_po_count
2683: FROM po_headers_all
2684: WHERE po_header_id IN (SELECT po_header_id
2685: FROM ap_invoice_lines_All
2686: WHERE invoice_id = p_invoice_id);
2687:
2688: IF l_po_count = 1 THEN
2689: SELECT po_header_id

Line 2693: FROM ap_invoice_lines_All

2689: SELECT po_header_id
2690: INTO l_po_header_id
2691: FROM po_headers_all POH
2692: WHERE po_header_id IN ( SELECT po_header_id
2693: FROM ap_invoice_lines_All
2694: WHERE invoice_id = p_invoice_id);
2695: END IF;
2696: END IF;
2697: --

Line 2722: FROM ap_invoice_lines_All

2718: SELECT COUNT(*)
2719: INTO l_release_count
2720: FROM po_releases_all pr
2721: WHERE po_header_id IN (SELECT po_header_id
2722: FROM ap_invoice_lines_All
2723: WHERE invoice_id = p_invoice_id);
2724: --
2725: IF l_release_count = 1 THEN
2726: --