tag:blogger.com,1999:blog-5954268311855527678.post3725099103523503470..comments2024-03-18T05:45:05.913-07:00Comments on Oracle Apps Knowledge Sharing: Key Flex Field Structures & How to Retrieve Information about segments based on code combination idUnknownnoreply@blogger.comBlogger3125tag:blogger.com,1999:blog-5954268311855527678.post-71088402193934687412022-12-07T06:54:42.813-08:002022-12-07T06:54:42.813-08:00Can somebody please explain how to link flex field...Can somebody please explain how to link flex field value to person assignment. I need to find out the value against a person assignment Ankurhttps://www.blogger.com/profile/07021078094320264730noreply@blogger.comtag:blogger.com,1999:blog-5954268311855527678.post-73615905132826605182022-02-10T20:56:28.462-08:002022-02-10T20:56:28.462-08:00excellent queries and explanationexcellent queries and explanationAshish Gnoreply@blogger.comtag:blogger.com,1999:blog-5954268311855527678.post-66954768522648004932017-11-27T19:56:49.082-08:002017-11-27T19:56:49.082-08:00awesome :)
i have used this :
SELECT fifs.segment_...awesome :)<br />i have used this :<br />SELECT fifs.segment_name<br /> ,fifs.segment_num<br /> ,ffv.flex_value<br /> ,ffvt.description<br /><br />FROM fnd_flex_values ffv<br /> ,fnd_flex_values_tl ffvt<br /> ,fnd_id_flex_segments fifs<br /> ,gl_code_combinations glv<br />WHERE ffv.flex_value_id = ffvt.flex_value_id<br />AND ffv.flex_value_set_id = Oracle Knowledge Pointhttps://www.blogger.com/profile/12958545404967717469noreply@blogger.com