LiveLabs & Workshops

SELECT EMPCODE,EMP_DESIG,DEPT_CODE,PRODUCT_ID,REQUEST_DATE,APEX_ITEM.TEXT(1,REQUEST_QTY) REQUEST_QTY,APEX_ITEM.TEXT(2) AS issued,APEX_ITEM.TEXT(3) AS balance FROM STORE_PRODUCT_ISSUED;