SQL & PL/SQL

Hi All,

I have a SQL PLPUS script which generates the CSV file, the problem is whenever I run manually(@c:\future_cost.sql) it's works.

I am trying to generate this CSV from Concurrent program my request is completed successfully but it is not throughing data into my CSV.

Please is anybody have clue I apprechiate you in advance.
=================
SET ECHO OFF
SET FEEDBACK OFF
SET HEADING OFF
SET VERIFY OFF
SET PAGESIZE 0
SET LINESIZE 1200
spool C:/current_f_cost.csv
SELECT 'ORG_NAME,ITEM,Cost_ID,DESCRIPTION,Material_Cst,Current_Future_Cst_Field,Currency,Eff_Date,Variance,Percentage,USER_NAME'
FROM DUAL
UNION ALL
SELECT ORG.ORGANIZATION_CODE||','||MTL.SEGMENT1||','||CST.COST_TYPE_ID||','||TRANSLATE(MTL.DESCRIPTION,',',' ')||','||
CST.MATERIAL_COST||','||(CASE WHEN CST.ATTRIBUTE2='EUR' THEN ROUND(CST.ATTRIBUTE1*1.44,2)
WHEN CST.ATTRIBUTE2 IN('USD','CAD')THEN ROUND(CST.ATTRIBUTE1,2) END)||','||CST.ATTRIBUTE2||','||
To_Char(To_Date(CST.ATTRIBUTE3,'YYYY/MM/DD HH24:MI:SS'),'DD-MON-YY')||','||
(CASE WHEN CST.ATTRIBUTE2 = 'EUR' THEN NVL((CST.MATERIAL_COST - CST.ATTRIBUTE1*1.44),0)
WHEN CST.ATTRIBUTE2 IN('USD','CAD') THEN CST.MATERIAL_COST - CST.ATTRIBUTE1 END)||','||
(CASE
WHEN
CST.ATTRIBUTE2='EUR'
THEN
DECODE(TRUNC(((CST.MATERIAL_COST-CST.ATTRIBUTE1*1.44)*100)/CST.MATERIAL_COST),TRUNC(((CST.MATERIAL_COST-CST.ATTRIBUTE1*1.44)*100)/CST.MATERIAL_COST),TRUNC(((CST.MATERIAL_COST-CST.ATTRIBUTE1*1.44)*100)/CST.MATERIAL_COST)||'%')
ELSE
Decode(NVL(TRUNC(((CST.MATERIAL_COST-CST.ATTRIBUTE1)*100)/CST.MATERIAL_COST,0),0),
NVL(TRUNC(((CST.MATERIAL_COST-CST.ATTRIBUTE1)*100)/CST.MATERIAL_COST,0),0),NVL(TRUNC(((CST.MATERIAL_COST-CST.ATTRIBUTE1)*100)/CST.MATERIAL_COST,0),0)||'%')
END)||','||TRANSLATE(HR.FULL_NAME,',',' ')
FROM
APPS.CST_ITEM_COSTS CST,
APPS.MTL_SYSTEM_ITEMS MTL,
APPS.CST_COST_TYPES CSTT,
APPS.ORG_ORGANIZATION_DEFINITIONS ORG,
APPS.HR_EMPLOYEES HR
WHERE CST.INVENTORY_ITEM_ID=MTL.INVENTORY_ITEM_ID
AND CST.ORGANIZATION_ID=MTL.ORGANIZATION_ID
AND CST.ORGANIZATION_ID=ORG.ORGANIZATION_ID
AND MTL.BUYER_ID=HR.EMPLOYEE_ID
AND CST.ATTRIBUTE1 !=0 AND CST.ITEM_COST > CST.ATTRIBUTE1*1.3
AND CST.MATERIAL_COST >0
AND MTL.PLANNING_MAKE_BUY_CODE=2
AND MTL.ITEM_TYPE='P'
AND CST.cost_type_id = CSTT.cost_type_id
AND CSTT.COST_TYPE='Current'
And rownum<10;
Spool off
/
=========================================================


Thanks,
Zeeshan