Export data
Dear,
SELECT TD.TOOL_DEPT
, TD.TOOL_NUMBER
, TM.TOOL_DESCRIPTION
, TM.ITEM_CODE
, TM.ITEM_ID
, TM.TOOL_SPECIFICATION
, decode(TD.TOTAL_QUANTITY,0, NULL ,TD.TOTAL_QUANTITY) AS TOTAL_QUANTITY
, decode(SIGN(NVL(TD.TOTAL_QUANTITY,0) - (NVL(TD.LENDING_QUANTITY,0) +NVL(TD.R_S_QUANTITY,0)+NVL(TD.standby_rs,0)+NVL(TD.standby_loss,0))),1,NVL(TD.TOTAL_QUANTITY,0) - (NVL(TD.LENDING_QUANTITY,
Please hepl me.
I make form and i export data from menu.
But it is only display some fields that display
1. Make View
2. datablock, I chooce View
CREATE OR REPLACE VIEW ZSCM_TM_TOOL_LIST_DEPT_V ASSELECT TD.TOOL_DEPT
, TD.TOOL_NUMBER
, TM.TOOL_DESCRIPTION
, TM.ITEM_CODE
, TM.ITEM_ID
, TM.TOOL_SPECIFICATION
, decode(TD.TOTAL_QUANTITY,0, NULL ,TD.TOTAL_QUANTITY) AS TOTAL_QUANTITY
, decode(SIGN(NVL(TD.TOTAL_QUANTITY,0) - (NVL(TD.LENDING_QUANTITY,0) +NVL(TD.R_S_QUANTITY,0)+NVL(TD.standby_rs,0)+NVL(TD.standby_loss,0))),1,NVL(TD.TOTAL_QUANTITY,0) - (NVL(TD.LENDING_QUANTITY,
0