DBA Data[Home] [Help]

APPS.PO_COPYDOC_SUB dependencies on PO_VENDOR_SITES_ALL

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'