DBA Data[Home] [Help]

APPS.MRP_SOURCING_GRP dependencies on PO_VENDOR_SITES_ALL

Line 355: po_vendor_sites_all site,

351: IF var_vendor_id IS NOT NULL THEN
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)