Query of PARTICULARS/DESCRIPTION field auto-complete.
SELECT ITEMS
FROM CMS.V_MASTER_COMPEXP
WHERE USERNAME = '[usr_name]' AND COSTCENTER_CODE = '{CHARGE_CC}' AND PLANT = '{PLANT}'
ORDER BY ITEMS
Scenario that I need:
When I change the PLANT, the PARTICULARS/DESCRIPTION data will be cleared or the value will be set to null.
When I change the CHARGE TO COST CENTER, the PARTICULARS/DESCRIPTION and PLANT data will be cleared or the value will be set to null.