APPS.POS_AP_INVOICES_PKG dependencies on PO_RELEASES_ALL

Line 36: po_releases_all pr

32: SELECT DISTINCT (ph.clm_document_number||'-'||pr.release_num)
33: FROM ap_invoice_distributions_all aid,
34: po_distributions_all pd,
35: po_headers_all ph,
36: po_releases_all pr
37: WHERE aid.invoice_id = l_invoice_id
38: AND aid.po_distribution_id = pd.po_distribution_id
39: AND pr.po_release_id = pd.po_release_id
40: AND ph.po_header_id = pr.po_header_id

Line 412: po_releases_all pr

408: union all
409: select distinct (ph.clm_document_number||'-'||pr.release_num), ph.po_header_id, pr.po_release_id
410: from ap_invoice_lines_all ail,
411: po_headers_all ph,
412: po_releases_all pr
413: WHERE ail.invoice_id = l_invoice_id and
414: pr.po_release_id = ail.po_release_id and
415: ph.po_header_id = ail.po_header_id and
416: ph.type_lookup_code = 'BLANKET' ;

Line 432: po_releases_all pr

428: SELECT DISTINCT (ph.segment1||'-'||pr.release_num),ph.po_header_id, pr.po_release_id
429: FROM ap_invoice_distributions_all aid,
430: po_distributions_all pd,
431: po_headers_all ph,
432: po_releases_all pr
433: WHERE aid.invoice_id = l_invoice_id
434: AND aid.po_distribution_id = pd.po_distribution_id
435: AND pr.po_release_id = pd.po_release_id
436: AND ph.po_header_id = pr.po_header_id