Script to find DFF information

SELECT FDF.TITLE "DFF Title",
         FDF.APPLICATION_TABLE_NAME "Application Table",
         FDF.CONTEXT_COLUMN_NAME "Context Column Name",
         --
         FDFCU.DESCRIPTIVE_FLEX_CONTEXT_CODE "DFF Context Code",
         FDFCU.COLUMN_SEQ_NUM "Sequence",
         FDFCU.END_USER_COLUMN_NAME "Segment Name",
         FDFCU.APPLICATION_COLUMN_NAME "Column Name",
         --
         FFV.FLEX_VALUE_SET_NAME "Value Set Name"
    FROM APPS.FND_DESCR_FLEX_COL_USAGE_VL FDFCU,
         APPS.FND_DESCRIPTIVE_FLEXS_VL FDF,
         APPS.FND_FLEX_VALUE_SETS FFV
   WHERE     1 = 1
         --
         AND FDF.TITLE = 'Further Job Information'              -- <change it>
         AND FDFCU.DESCRIPTIVE_FLEX_CONTEXT_CODE = 'US'         -- <change it>
         AND FDFCU.ENABLED_FLAG = 'Y'
         --
         AND FDFCU.FLEX_VALUE_SET_ID = FFV.FLEX_VALUE_SET_ID
         AND FDFCU.DESCRIPTIVE_FLEXFIELD_NAME = FDF.DESCRIPTIVE_FLEXFIELD_NAME
         AND FDFCU.APPLICATION_ID = FDF.APPLICATION_ID
--
ORDER BY FDFCU.DESCRIPTIVE_FLEXFIELD_NAME,
         FDFCU.DESCRIPTIVE_FLEX_CONTEXT_CODE,
         FDFCU.COLUMN_SEQ_NUM;

No comments:

Post a Comment