Friday 2 September 2011

Query for finding the value set attached to Descriptive Flex Fields

SELECT V.APPLICATION_ID,
FA.APPLICATION_NAME,
FD.TITLE,
V.descriptive_flex_context_code,
V.end_user_column_name,
v.APPLICATION_COLUMN_NAME,
F.FLEX_VALUE_SET_NAME,
DECODE(f.VALIDATION_TYPE,'F', 'TABLE',
'I','INDEPENDENT',
'D', 'DEPENDENT',
'N', 'NONE',
'P', 'PAIR',
'U', 'SPECIAL',
'X', 'TRANSLATABLE INDEPENDENT',
'Y', 'TRANSLATABLE DEPENDENT') VALIDATION_TYPE
FROM fnd_descr_flex_col_usage_vl V,
FND_FLEX_VALUE_SETS F,
FND_APPLICATION_TL FA,
FND_DESCRIPTIVE_FLEXS_VL FD
WHERE V.descriptive_flexfield_name NOT LIKE '$SRS$.%'
AND V.FLEX_VALUE_SET_ID = F.FLEX_VALUE_SET_ID
AND V.APPLICATION_ID = FA.APPLICATION_ID
AND FA.APPLICATION_ID = FD.APPLICATION_ID
AND V.DESCRIPTIVE_FLEXFIELD_NAME = FD.DESCRIPTIVE_FLEXFIELD_NAME

No comments:

Post a Comment