Issue/Symptom/Question

We almost created a duplicate vendor because the LOV only shows Active Vendors.  Can the LOV be modified to show Inactive Vendors too?  How can we search inactive vendors without being in the vendors screen?

Applies To

Customize List of Values (LOV)

Resolution/Fix/Answer

1) Go to the Customize List of Values window (System Management > Technical Support)

2) Query LOV 95 (might need to load LOV 95 if it hasn't been loaded yet)

3) change the SQL to this:

SELECT V.VEN_ID,
V.VEN_TYPE_CD,
SUBSTR(V.NAME || DECODE(V.NAME_PREFIX, NULL, '', ' ' ||
V.NAME_PREFIX), 1, 25),
SUBSTR(pk_vendor.f_remitAddrStr(V.VEN_ID), 1, 33),
V.VEN_STAT_CD
FROM VENDOR V,
VENDOR_CLASS
WHERE V.VEN_STAT_CD in ('A','I')
AND pk_miscSecurity.f_userAuthorized(V.G_ALL_OU_CD,
'VALID_VEN',
'VEN_ID',
NULL,
NULL,
V.VEN_ID,
NULL,
NULL,
NULL,
pk_pentaLogin.f_getUserId) = 'Y'
AND VENDOR_CLASS.SUPPLIER_CD = 'Y'
AND VENDOR_CLASS.VEN_CLASS_CD = V.VEN_CLASS_CD
ORDER BY UPPER( V.NAME ), V.VEN_ID

4) Change the Name of the LOV to "Active/Inactive Vendors"

5) Add the Vendor Status Column to the LOV

6) Go to the Generate List of Values window (System Management > Technical Support)

7) Query LOV 95 and select it (row turns blue when selected)

8) Click the Generate button on bottom left to make the changes effective

9) Close the window

If the LOV 95 gets messed up or stops working, Delete the LOV and Load Standard... again.  PENTA keeps the Standards to be used when customization doesn't exist.