APPS.PO_COPYDOC_SUB dependencies on PO_VENDOR_SITES

Line 475: FROM PO_VENDOR_SITES

471: x_ship_via_lookup_code,
472: x_fob_lookup_code,
473: x_freight_terms_lu_code,
474: x_terms_id
475: FROM PO_VENDOR_SITES
476: WHERE vendor_id = x_vendor_id
477: AND vendor_site_id = x_vendor_site_id;
478:
479: EXCEPTION

Line 613: FROM PO_VENDOR_SITES

609: x_progress := '002';
610: BEGIN
611: SELECT distinct 'Y'
612: INTO x_valid_flag
613: FROM PO_VENDOR_SITES
614: WHERE vendor_site_id = x_vendor_site_id
615: AND vendor_id = x_vendor_id
616: AND nvl(rfq_only_site_flag,'N') <> 'Y'
617: AND purchasing_site_flag = 'Y'

Line 3110: FROM po_vendor_sites_all pvsa

3106: )
3107: OR
3108: NOT EXISTS
3109: (SELECT 'Valid vendor site for POU'
3110: FROM po_vendor_sites_all pvsa
3111: WHERE pvsa.vendor_id = p_vendor_id
3112: AND pvsa.org_id = psg.num2
3113: AND pvsa.purchasing_site_flag = 'Y'
3114: AND NVL(pvsa.rfq_only_site_flag, 'N') = 'N'

Line 3158: FROM po_vendor_sites_all pvsa

3154: FROM po_session_gt psg
3155: WHERE psg.key = l_key
3156: AND NOT EXISTS
3157: (SELECT 'Valid vendor site'
3158: FROM po_vendor_sites_all pvsa
3159: WHERE pvsa.vendor_site_id = psg.num3
3160: AND pvsa.vendor_id = p_vendor_id
3161: AND pvsa.org_id = psg.num2
3162: AND pvsa.purchasing_site_flag = 'Y'