APPS.AP_ISP_UTILITIES_PKG dependencies on PO_HEADERS_ALL

Line 325: FROM po_headers_all

321: END IF;
322:
323: SELECT terms_id
324: INTO p_terms_id
325: FROM po_headers_all
326: WHERE po_header_id = l_po_header_id
327: AND type_lookup_code in ('BLANKET', 'PLANNED', 'STANDARD');
328:
329: debug_info := l_api_name || ': p_terms_id = ' || p_terms_id;

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 367: po_headers_all p,

363: BEGIN
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

Line 2589: FROM po_headers_all

2585: RETURN 'UNMATCHED';
2586: ELSE
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:

Line 2636: FROM po_headers_all POH

2632: SELECT SEGMENT1,
2633: po_header_id
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:

Line 2683: FROM po_headers_all

2679: IF l_count <> 0 THEN
2680:
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:

Line 2691: FROM po_headers_all POH

2687:
2688: IF l_po_count = 1 THEN
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;