SELECT fa.application_id "Application ID",
fat.application_name "Application Name",
fa.application_short_name "Application Short Name",
fa.basepath "Basepath"
FROM fnd_application fa,
fnd_application_tl fat
WHERE fa.application_id = fat.application_id
AND fat.language = USERENV('LANG')
AND fat.application_name in ('Receivables','Purchasing','Payables','General Ledger','CUSTOM_APPLICATION_NAME') -- <change it>
ORDER BY fat.application_name;
fat.application_name "Application Name",
fa.application_short_name "Application Short Name",
fa.basepath "Basepath"
FROM fnd_application fa,
fnd_application_tl fat
WHERE fa.application_id = fat.application_id
AND fat.language = USERENV('LANG')
AND fat.application_name in ('Receivables','Purchasing','Payables','General Ledger','CUSTOM_APPLICATION_NAME') -- <change it>
ORDER BY fat.application_name;
No comments:
Post a Comment