View: OKL_BPD_VENDOR_SITES_V

Product:	OKL - Lease and Finance Management
Description:
Implementation/DBA Data:	APPS.OKL_BPD_VENDOR_SITES_V

View Text

SELECT POV.VENDOR_NAME
, POVS.VENDOR_SITE_CODE
, POVS.VENDOR_SITE_ID
FROM PO_VENDORS POV
, PO_VENDOR_SITES_ALL POVS
WHERE POVS.VENDOR_ID = POV.VENDOR_ID
AND NVL(POVS.PAY_SITE_FLAG
, 'Y') = 'Y'
AND NVL(POV.ENABLED_FLAG
, 'Y') = 'Y'
AND NVL(POV.END_DATE_ACTIVE
, SYSDATE +1) > SYSDATE

Columns