DBA Data[Home] [Help]

APPS.PO_COPYDOC_SUB dependencies on PO_VENDOR_SITES_ALL

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'