Query to get Descriptive Flex Field and Attributes

Query to get Descriptive Flex Field and Attributes

SELECT FFV.APPLICATION_TABLE_NAME,
       FFV.DESCRIPTIVE_FLEXFIELD_NAME,
       FFV.CONTEXT_COLUMN_NAME,
       FFV.TITLE,
       ATT.APPLICATION_COLUMN_NAME,
       ATT.END_USER_COLUMN_NAME,
       ATT.COLUMN_SEQ_NUM,
       ATT.ENABLED_FLAG,
       ATT.REQUIRED_FLAG,
       ATT.SECURITY_ENABLED_FLAG,
       ATT.DISPLAY_FLAG,
       ATT.FLEX_VALUE_SET_ID,
       ATT.FORM_LEFT_PROMPT,
       FFV.*
  FROM FND_DESCRIPTIVE_FLEXS_VL FFV, FND_DESCR_FLEX_COL_USAGE_VL ATT
 WHERE     FFV.DESCRIPTIVE_FLEXFIELD_NAME = ATT.DESCRIPTIVE_FLEXFIELD_NAME
       AND FFV.DESCRIPTIVE_FLEXFIELD_NAME = 'JTF_RS_RESOURCE_EXTNS'
       AND FFV.TITLE LIKE '%Resource%'

*/

5 comments:

  1. Thanks and Regards. Oracle Apps R12 & Fusion Training Videos at affordable cost. please check oracleappstechnical.com for details.

    ReplyDelete
  2. 25% OFF on Oracle Apps R12 Financials Self Paced Course along with 11 Additional Add On Courses (321 Session Videos of 120 Hours Recordings). Our Top Trending Course with 1700 Enrolled Udemy Students

    Please Check https://www.oracleappstechnical.com for details

    ReplyDelete