Using SQL*Plus, to retrieve the sources, please do the following :
1. From the Define concurrent Program forms, query your PL/SQL concurrent program then note Executable Name .
2. Go to the Define Executable forms, query the executable name of step 1 then note the Execution File Name.
An executable file name is generally formatted as :
3. To retrieve the source, connect to apps then run the following sql statement from SQL*Plus :
set long 20000
set pages 9999
set lines 80
select text from user_source
where name ='
order by line