DBA Data[Home] [Help]

APPS.POS_AP_CHECKS_PKG dependencies on PO_RELEASES_ALL

Line 30: po_releases_all pr

26: SELECT DISTINCT (ph.segment1||'-'||pr.release_num), ph.po_header_id, pr.po_release_id
27: FROM ap_invoice_distributions_all aid,
28: po_distributions_all pd,
29: po_headers_all ph,
30: po_releases_all pr
31: WHERE aid.invoice_id in (select invoice_id
32: from ap_invoice_payments_all
33: where check_id = l_check_id)
34: AND aid.po_distribution_id = pd.po_distribution_id