DBA Data[Home] [Help]

APPS.GMD_SPEC_VRS_GRP dependencies on PO_VENDOR_SITES_ALL

Line 3552: FROM po_vendor_sites_all v

3548: AND nvl(v.end_date_active, sysdate+1);
3549:
3550: CURSOR c_supplier_site IS
3551: SELECT 1
3552: FROM po_vendor_sites_all v
3553: WHERE (v.purchasing_site_flag = 'Y'
3554: OR v.rfq_only_site_flag = 'Y')
3555: AND sysdate < NVL(inactive_date, sysdate + 1)
3556: AND v.vendor_id = p_supp_vr.supplier_id