Finding Application ID's accross Fusion Modules

 

        Where to find Application IDs

Fetch all application ids script

SELECT application_id,
       application_short_name,
       product_code
FROM   fnd_application 

-------------------------------------------------

Specific Application ID's SQL Script

SELECT application_id,
       application_short_name,
       product_code
FROM   fnd_application
WHERE  application_id IN ( 199, 201, 210, 224 )
ORDER  BY application_id 

-----------------------

SELECT fa.application_id,

       fa.application_short_name,
       fatl.application_name
FROM   fnd_application fa,
       fnd_application_tl fatl
WHERE  1 = 1
       AND fa.application_id = fatl.application_id
       AND fatl.language = 'US'
       AND ( fa.application_short_name IN ( 'GL', 'AP', 'AR', 'CE',
                                            'FA', 'XLA' ) -- Finance
              OR fa.application_short_name IN ( 'PO', 'INV', 'WSH', 'RCV', 'DOO'
                                              )
              -- SCM/Procurement
              OR fa.application_short_name IN ( 'PER', 'PAY', 'BEN', 'HRC' )
            -- HCM
            )
ORDER  BY fa.application_short_name 

For the Result, click on the below link:

Click Here