Query to find whether a product is installed/licensed or not.

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13

SELECT fat.application_name, 
       fa.application_id, 
       fpi.patch_level, 
       Decode(fpi.status, 'I', 'Licensed', 
                          'N', 'Not Licensed', 
                          'S', 'Shared', 
                          'Undetermined') STATUS 
FROM   fnd_product_installations fpi, 
       fnd_application fa, 
       fnd_application_tl fat 
WHERE  fpi.application_id = fa.application_id 
       AND fat.application_id = fa.application_id 
       AND fat.language = 'US'; 

1
2
3
4

SELECT application_short_name, 
       application_id 
FROM   fnd_application_vl 
WHERE  application_name LIKE '%Payables%'

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15

SELECT fat.application_name, 
       fa.application_id, 
       fpi.patch_level, 
       Decode(fpi.status, 'I', 'Licensed', 
                          'N', 'Not Licensed', 
                          'S', 'Shared', 
                          'Undetermined') STATUS 
FROM   fnd_product_installations fpi, 
       fnd_application fa, 
       fnd_application_tl fat 
WHERE  fpi.application_id = fa.application_id 
       AND fat.application_id = fa.application_id 
       AND fa.application_short_name = 'ZX' 
          --Here ZX Represnts EBTax, Short Name for EBusiness Tax
       AND fat.language = 'US';