APPS.POS_AP_INVOICES_PKG dependencies on PO_RELEASES_ALL

Line 36: po_releases_all pr

32: SELECT DISTINCT (ph.segment1||'-'||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 410: po_releases_all pr

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

Line 430: po_releases_all pr

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