APPS.PO_COPYDOC_SUB dependencies on PO_VENDOR_SITES

Line 518: FROM PO_VENDOR_SITES

514: x_ship_via_lookup_code,
515: x_fob_lookup_code,
516: x_freight_terms_lu_code,
517: x_terms_id
518: FROM PO_VENDOR_SITES
519: WHERE vendor_id = x_vendor_id
520: AND vendor_site_id = x_vendor_site_id;
521:
522: EXCEPTION

Line 656: FROM PO_VENDOR_SITES

652: x_progress := '002';
653: BEGIN
654: SELECT distinct 'Y'
655: INTO x_valid_flag
656: FROM PO_VENDOR_SITES
657: WHERE vendor_site_id = x_vendor_site_id
658: AND vendor_id = x_vendor_id
659: AND nvl(rfq_only_site_flag,'N') <> 'Y'
660: AND purchasing_site_flag = 'Y'

Line 3304: FROM po_vendor_sites_all pvsa

3300: )
3301: OR
3302: NOT EXISTS
3303: (SELECT 'Valid vendor site for POU'
3304: FROM po_vendor_sites_all pvsa
3305: WHERE pvsa.vendor_id = p_vendor_id
3306: AND pvsa.org_id = psg.num2
3307: AND pvsa.purchasing_site_flag = 'Y'
3308: AND NVL(pvsa.rfq_only_site_flag, 'N') = 'N'

Line 3352: FROM po_vendor_sites_all pvsa

3348: FROM po_session_gt psg
3349: WHERE psg.key = l_key
3350: AND NOT EXISTS
3351: (SELECT 'Valid vendor site'
3352: FROM po_vendor_sites_all pvsa
3353: WHERE pvsa.vendor_site_id = psg.num3
3354: AND pvsa.vendor_id = p_vendor_id
3355: AND pvsa.org_id = psg.num2
3356: AND pvsa.purchasing_site_flag = 'Y'