DBA Data[Home] [Help]

APPS.MRP_SOURCING_API_PK dependencies on PO_VENDORS

Line 340: po_vendors ven

336: SELECT site.vendor_site_code
337: INTO var_new_site_code
338: FROM
339: po_vendor_sites_all site,
340: po_vendors ven
341: WHERE NVL(ven.enabled_flag, 'N') = 'Y'
342: AND SYSDATE BETWEEN NVL(ven.start_date_active, SYSDATE -1)
343: AND NVL(ven.end_date_active, sysdate+1)
344: AND SYSDATE < NVL(site.inactive_date, SYSDATE + 1)

Line 443: po_vendors ven

439: select dest_site.vendor_site_id
440: into arg_vendor_site_id
441: FROM org_organization_definitions oog,
442: po_vendor_sites_all dest_site,
443: po_vendors ven
444: WHERE NVL(ven.enabled_flag, 'N') = 'Y'
445: AND sysdate BETWEEN NVL(ven.start_date_active, sysdate -1)
446: AND NVL(ven.end_date_active, sysdate+1)
447: AND ven.vendor_id = arg_vendor_id