concurrent program tables in oracle apps

SQL query to find out the concurrent programs attaching to a plsql package

Please find below the query to find Concurrent Programs being attached to a particular PL /SQL Package . The below query can be modified to search Concurrent Program based on addiitonal conditions . Uncomment the condition and pass required parameters to get the desired search results SELECT PROG.CONCURRENT_PROGRAM_ID, PROG.USER_CONCURRENT_PROGRAM_NAME, PROG.CONCURRENT_PROGRAM_NAME , DECODE(EXE.EXECUTION_METHOD_CODE ,  ‘I’, ‘PL/SQL’ […]

Scroll to top
Copy Protected by Chetan's WP-Copyprotect.