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:
