DBA Data[Home] [Help]

APPS.PO_THIRD_PARTY_STOCK_GRP dependencies on PO_RELEASES_ALL

Line 990: FROM po_releases_all por, po_headers_all poh

986: AND NVL(closed_code, 'a') <> 'FINALLY CLOSED'
987: AND NVL(cancel_flag, 'N') = 'N')
988: OR EXISTS
989: (SELECT 'x'
990: FROM po_releases_all por, po_headers_all poh
991: WHERE por.consigned_consumption_flag = 'Y'
992: AND poh.vendor_site_id = p_vendor_site_id
993: AND poh.vendor_id = p_vendor_id --bug 3649022
994: AND poh.po_header_id = por.po_header_id

Line 999: FROM po_line_locations_all pol, po_releases_all por,

995: AND nvl(por.closed_code, 'a') <> 'FINALLY CLOSED'
996: AND nvl(por.cancel_flag, 'N') = 'N')
997: OR EXISTS
998: (SELECT 'x'
999: FROM po_line_locations_all pol, po_releases_all por,
1000: po_headers_all poh
1001: WHERE poh.vendor_site_id = p_vendor_site_id
1002: AND poh.vendor_id = p_vendor_id --bug 3649022
1003: AND por.po_header_id = poh.po_header_id