Kintana Script : Oracle Applications Short Names

Purpose

Kintana validation sql to return a list of Oracle Applications short 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 fa.application_short_name,
       fa.application_short_name
from   FND_APPLICATION@INSTANCE_link fa
where  fa.application_id in
       (select distinct fcp.application_id
        from FND_CONCURRENT_PROGRAMS@INSTANCE_link fcp
       )
order by 1

Download

KintanaScripts.zip (64 Kb)