DBA Data[Home] [Help]

APPS.MRP_SOURCING_GRP dependencies on PO_VENDORS

Line 356: po_vendors ven

352: SELECT site.vendor_site_code
353: INTO var_new_site_code
354: FROM
355: po_vendor_sites_all site,
356: po_vendors ven
357: WHERE NVL(ven.enabled_flag, 'N') = 'Y'
358: AND SYSDATE BETWEEN NVL(ven.start_date_active, SYSDATE -1)
359: AND NVL(ven.end_date_active, sysdate+1)
360: AND SYSDATE < NVL(site.inactive_date, SYSDATE + 1)