Query to retrieve KFF's in Oracle E-Business Suite
SELECT COUNT (*), fat.application_name
FROM fnd_id_flexs fif, fnd_application_tl fat
WHERE fat.application_id = fif.application_id
AND fat.LANGUAGE = 'US'
GROUP BY fat.application_name
ORDER BY fat.application_name
SELECT a.application_short_name, fat.application_name, fif.id_flex_code,
fif.id_flex_name
FROM fnd_id_flexs fif, fnd_application fa, fnd_application_tl fat
WHERE fa.application_id = fif.application_id
AND fat.application_id = fa.application_id
AND fat.LANGUAGE = 'US'ORDER BY fat.application_name, fif.id_flex_name
No comments:
Post a Comment