For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
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;
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;