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;
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