Kintana Script : Oracle Applications Concurrent Programs

Purpose

Kintana validation sql code to return a list of Oracle Applications Concurrent Program Names.

Tested

With HP PPM (Project and Portfolio Management) Kintana v6.0.

Usage

Paste the script into Toad or SQL Runner

-- Change the INSTANCE to match your naming conventions:
-- e,g : dev, qa, perf, prod

select fcp.concurrent_program_name,
       fcp.user_concurrent_program_name
from   FND_CONCURRENT_PROGRAMS_vl@INSTANCE_link fcp
where  fcp.application_id in
       (select fa.application_id
        from FND_APPLICATION@INSTANCE_link fa
        where fa.application_short_name like 'AP' -- '%[P.P_APP_SHORT_NAME]'
       )
order by 2

Download

KintanaScripts.zip (64 Kb)