Lists all products and their Installation Status
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';
Query to find the Short Name for a Particular Application
SELECT application_short_name,
application_id
FROM fnd_application_vl
WHERE application_name LIKE '%Payables%'
Query to find Installation Status of a Particular Product
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';
Comments
Post a Comment