Oracle Fusion : SQL query to Fetch Key Flex Fields Segment Values and Description

SQL query to Fetch Key Flex Fields Segment Values and Description

 

Hi Friends, In this post I will share you the Tables and Sql Query of Key Flex Fields Segments value sets. In Fusion these value set tables has been totally changed as compared to Oracle r12. Please find below SQL query to Fetch Key Flex Fields Segment Values and Description

 

 

KFF Value Set Tables

 

1.FND_VS_VALUE_SETS

2.FND_VS_VALUES_B

 

Sql Query

 

 select *

from FND_VS_VALUE_SETS a1,FND_VS_VALUES_B a2
where a1.VALUE_SET_CODE=:KFF_SEGMENT_NAME
and a1.VALUE_SET_ID =a2.VALUE_SET_ID

SQL query to Fetch Key Flex Fields Segment Values and Description