Wednesday, February 9, 2022

Query to retrieve KFF's in Oracle E-Business Suite

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

Types of animations

Animation is a diverse and creative field with a variety of styles that artists and filmmakers use to bring their visions to life. Here are ...