APPS.AP_ISP_UTILITIES_PKG dependencies on PO_HEADERS_ALL

Line 329: FROM po_headers_all

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

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

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

Line 2950: FROM po_headers_all

2946: RETURN 'UNMATCHED';
2947: ELSE
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:

Line 2997: FROM po_headers_all POH

2993: SELECT NVL(CLM_DOCUMENT_NUMBER, SEGMENT1), -- for CLM Bug 9503239
2994: po_header_id
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:

Line 3044: FROM po_headers_all

3040: IF l_count <> 0 THEN
3041:
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:

Line 3052: FROM po_headers_all POH

3048:
3049: IF l_po_count = 1 THEN
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;