DBA Data[Home] [Help]

APPS.POS_VIEW_RECEIPTS_GRP dependencies on PO_RELEASES_ALL

Line 302: FROM rcv_shipment_lines rsl, po_headers_all ph, po_releases_all pr

298:
299: -- Declare cursor to retrieve the PO number for Supplier View.
300: CURSOR po_cursor(l_shipment_header_id number) IS
301: SELECT DISTINCT(ph.segment1||'-'||pr.release_num), ph.po_header_id, pr.po_release_id
302: FROM rcv_shipment_lines rsl, po_headers_all ph, po_releases_all pr
303: WHERE rsl.shipment_header_id= l_shipment_header_id
304: AND rsl.po_header_id = ph.po_header_id
305: AND rsl.po_release_id = pr.po_release_id
306: AND ph.type_lookup_code = 'BLANKET'