APPS.PO_THIRD_PARTY_STOCK_GRP dependencies on PO_HEADERS_ALL

Line 981: FROM po_headers_all

977: INTO l_open
978: FROM dual
979: WHERE EXISTS
980: (SELECT 'x'
981: FROM po_headers_all
982: WHERE consigned_consumption_flag = 'Y'
983: AND type_lookup_code = 'STANDARD'
984: AND vendor_site_id = p_vendor_site_id
985: AND vendor_id = p_vendor_id --bug 3649022

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 1000: po_headers_all poh

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
1004: AND pol.po_release_id = por.po_release_id

Line 1010: FROM po_line_locations_all pol, po_headers_all poh

1006: AND NVL(pol.closed_code, 'a') <> 'FINALLY CLOSED'
1007: AND NVL(pol.cancel_flag, 'N') = 'N')
1008: OR EXISTS
1009: (SELECT 'x'
1010: FROM po_line_locations_all pol, po_headers_all poh
1011: WHERE poh.vendor_site_id = p_vendor_site_id
1012: AND poh.vendor_id = p_vendor_id --bug 3649022
1013: AND poh.po_header_id = pol.po_header_id
1014: AND pol.consigned_flag = 'Y'