说明性弹性域段

SELECT FA.APPLICATION_NAME,
       DF.TITLE,
       FA.APPLICATION_SHORT_NAME,
       FA.BASEPATH,
       FA.PRODUCT_CODE,
       DF.CONCATENATED_SEGS_VIEW_NAME,
       DF.APPLICATION_TABLE_NAME,
       DF.DESCRIPTIVE_FLEXFIELD_NAME,
       DF.LAST_UPDATE_DATE,
       DF.LAST_UPDATED_BY,
       DF.CREATION_DATE,
       DF.CREATED_BY,
       DF.LAST_UPDATE_LOGIN,
       DF.CONTEXT_REQUIRED_FLAG,
       DF.CONTEXT_COLUMN_NAME,
       DF.CONTEXT_USER_OVERRIDE_FLAG,
       DF.CONCATENATED_SEGMENT_DELIMITER,
       DF.FREEZE_FLEX_DEFINITION_FLAG,
       DF.PROTECTED_FLAG,
       DF.CONTEXT_SYNCHRONIZATION_FLAG,
       DF.FORM_CONTEXT_PROMPT,
       DFC.DESCRIPTIVE_FLEXFIELD_NAME,
       DFC.DESCRIPTIVE_FLEX_CONTEXT_CODE,
       DFC.ENABLED_FLAG,
       DFC.GLOBAL_FLAG,
       DFC.DESCRIPTION,
       DFC.DESCRIPTIVE_FLEX_CONTEXT_NAME,
       DFCU.RUNTIME_PROPERTY_FUNCTION,
       DFCU.COLUMN_SEQ_NUM,
       DFCU.APPLICATION_COLUMN_NAME,
       DFCU.FORM_LEFT_PROMPT,
       DFCU.FORM_ABOVE_PROMPT,
       DFCU.END_USER_COLUMN_NAME,
       DFCU.FLEX_VALUE_SET_ID,
       FVS.FLEX_VALUE_SET_NAME,
       (CASE
           WHEN FVS.VALIDATION_TYPE = 'F' THEN
              (SELECT (   'SELECT '
                       || NVL2 (FVT.ID_COLUMN_NAME, FVT.ID_COLUMN_NAME || ',', '')
                       || NVL2 (FVT.VALUE_COLUMN_NAME, FVT.VALUE_COLUMN_NAME || ',', '')
                       || FVT.MEANING_COLUMN_NAME
                       || ' FROM '
                       || FVT.APPLICATION_TABLE_NAME
                       || ';')
                         SCRIPTS
                 FROM FND_FLEX_VALIDATION_TABLES FVT, FND_APPLICATION_TL FA
                WHERE     1 = 1
                      AND FA.APPLICATION_ID(+) = FVT.TABLE_APPLICATION_ID
                      AND FVT.FLEX_VALUE_SET_ID = FVS.FLEX_VALUE_SET_ID)
           --              CURSOR (
           --                 SELECT fa.application_name,
           --                        fvt.application_table_name,
           --                        fvt.summary_allowed_flag,
           --                        fvt.value_column_name,
           --                        fvt.value_column_type,
           --                        fvt.value_column_size,
           --                        fvt.meaning_column_name,
           --                        fvt.meaning_column_type,
           --                        fvt.meaning_column_size,
           --                        fvt.id_column_name,
           --                        fvt.id_column_type,
           --                        fvt.id_column_size,
           --                        --FVT.ADDITIONAL_WHERE_CLAUSE,
           --                        fvt.additional_quickpick_columns,
           --                        (   'SELECT '
           --                         || NVL2 (fvt.id_column_name, fvt.id_column_name || ',', '')
           --                         || NVL2 (fvt.value_column_name, fvt.value_column_name || ',', '')
           --                         || fvt.meaning_column_name
           --                         || ' FROM '
           --                         || fvt.application_table_name
           --                         || ';')
           --                           scripts
           --                   FROM fnd_flex_validation_tables fvt, fnd_application_tl fa
           --                  WHERE     1 = 1
           --                        AND fa.application_id(+) = fvt.table_application_id
           --                        AND fvt.flex_value_set_id = fvs.flex_value_set_id)
           WHEN FVS.VALIDATION_TYPE = 'I' THEN
              (   'SELECT FVV.FLEX_VALUE_ID,
       FVV.FLEX_VALUE,
       FVV.FLEX_VALUE_MEANING,
       FVV.DESCRIPTION
  FROM FND_FLEX_VALUES_VL FVV
WHERE     1 = 1
       AND FVV.ENABLED_FLAG = ''Y''
       AND SYSDATE BETWEEN NVL (FVV.START_DATE_ACTIVE, SYSDATE) AND NVL (FVV.END_DATE_ACTIVE, SYSDATE)
       AND FVV.FLEX_VALUE_SET_ID = '
               || FVS.FLEX_VALUE_SET_ID
               || ';')
        END)
          SCRIPTS,
       CURSOR (
          SELECT FLEX_VALUE,
                 FLEX_VALUE_MEANING,
                 DESCRIPTION,
                 ENABLED_FLAG,
                 SUMMARY_FLAG
            FROM FND_FLEX_VALUES_VL FFV
           WHERE     1 = 1
                 AND FFV.ENABLED_FLAG = 'Y'
                 AND SYSDATE BETWEEN NVL (FFV.START_DATE_ACTIVE, SYSDATE) AND NVL (FFV.END_DATE_ACTIVE, SYSDATE)
                 AND FFV.FLEX_VALUE_SET_ID = FVS.FLEX_VALUE_SET_ID)
          FLEX_VALUES_LIST,
       DFCU.ENABLED_FLAG,
       DFCU.REQUIRED_FLAG,
       DFCU.SECURITY_ENABLED_FLAG,
       DFCU.DISPLAY_FLAG,
       DFCU.DISPLAY_SIZE,
       DFCU.MAXIMUM_DESCRIPTION_LEN,
       DFCU.CONCATENATION_DESCRIPTION_LEN,
       DFCU.RANGE_CODE,
       DFCU.DEFAULT_TYPE,
       DFCU.DEFAULT_VALUE,
       FVS.VALIDATION_TYPE
  FROM FND_APPLICATION_VL FA,
       FND_DESCRIPTIVE_FLEXS_VL DF,
       FND_DESCR_FLEX_CONTEXTS_VL DFC,
       FND_DESCR_FLEX_COL_USAGE_VL DFCU,
       FND_FLEX_VALUE_SETS FVS
WHERE     1 = 1
       AND FVS.FLEX_VALUE_SET_ID(+) = DFCU.FLEX_VALUE_SET_ID
       AND FA.APPLICATION_ID = DF.APPLICATION_ID
       AND DFCU.ENABLED_FLAG = 'Y'
       AND DFC.ENABLED_FLAG = 'Y'
       AND DFCU.APPLICATION_ID = DFC.APPLICATION_ID
       AND DFCU.DESCRIPTIVE_FLEXFIELD_NAME = DFC.DESCRIPTIVE_FLEXFIELD_NAME
       AND DFCU.DESCRIPTIVE_FLEX_CONTEXT_CODE = DFC.DESCRIPTIVE_FLEX_CONTEXT_CODE
       AND DFC.APPLICATION_ID = DF.APPLICATION_ID
       AND DFC.DESCRIPTIVE_FLEXFIELD_NAME = DF.DESCRIPTIVE_FLEXFIELD_NAME
       AND DF.TITLE = '离散任务'
ORDER BY DFCU.COLUMN_SEQ_NUM;