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;