. /apps/${DATABASE}/appl_top/APPSORA.env

sqlplus -s ${USERNAME}/${PASSWORD} <<EOF

SET TERM OFF
SET NEWPAGE     0
SET SPACE       0
SET PAGESIZE    0
SET ECHO      OFF
SET FEEDBACK  OFF
SET HEADING   OFF
SET PAUSE     OFF
SET VERIFY OFF
set linesize 120

spool ${CONCPROG}.txt

select
fcr.REQUEST_ID”‘-’”
fu.user_name”‘-’”
fcr.PHASE_CODE”‘-’”
fcr.STATUS_CODE”‘-’”
trunc(( nvl(fcr.ACTUAL_COMPLETION_DATE,sysdate) –   fcr.ACTUAL_START_DATE) * 24 * 60,2)  ”‘-’”
–fcpt.USER_CONCURRENT_PROGRAM_NAME ”‘-’”
fcp.CONCURRENT_PROGRAM_NAME ”‘-’”
fcr.ACTUAL_START_DATE ”‘-’”
nvl(fcr.ACTUAL_COMPLETION_DATE,sysdate) RequestDetails
FROM
FND_CONCURRENT_REQUESTS FCR,
FND_CONCURRENT_PROGRAMS FCP,
FND_CONCURRENT_PROGRAMS_TL FCPT,
FND_USER FU
where  1=1
and    fcp.CONCURRENT_PROGRAM_ID=fcr.CONCURRENT_PROGRAM_ID
and    fcpt.CONCURRENT_PROGRAM_ID=fcp.CONCURRENT_PROGRAM_ID
AND    FCR.REQUESTED_BY = FU.USER_ID
AND    FU.USER_NAME = ‘${APPSUSER}’
and    fcp.CONCURRENT_PROGRAM_NAME = ‘${CONCPROG}’;

spool off;

EOF

# Grep "C-C" gives completed, normal status
RETVAL=`cat ${CONCPROG}.txt ‘ grep -i ${CONCPROG} ‘ grep -i "C-C" ‘ wc -l`; export RETVAL;
if [ ${RETVAL} != 0 ]
then
echo "${CONCPROG} completed successfully"
else
echo "${CONCPROG} not completed successfully"
fi