Introduction
A flexfield is a customizable flexible data field that you can customize according to business needs without coding. Oracle Applications uses two types of flexfields, key flexfields and descriptive flexfields. A key flexfield is a field you can customize to enter multi-segment values such as part numbers, account numbers, and so on. A descriptive flexfield is a field you customize to enter additional information for which your Oracle Applications product has not already provided a field
#Code#
SELECT FFV.DESCRIPTIVE_FLEXFIELD_NAME “DFF Name”
,FFV.APPLICATION_TABLE_NAME “Table Name”
,FFV.TITLE “Title”
,AP.APPLICATION_NAME “Application”
,FFC.DESCRIPTIVE_FLEX_CONTEXT_CODE “Context Code”
,FFC.DESCRIPTIVE_FLEX_CONTEXT_NAME “Context Name”
,FFC.DESCRIPTION “Context Desc”
,FFC.ENABLED_FLAG “Context Enable Flag”
,ATT.COLUMN_SEQ_NUM “Segment Number”
,ATT.FORM_LEFT_PROMPT “Segment Name”
,ATT.APPLICATION_COLUMN_NAME “Column”
,FVS.FLEX_VALUE_SET_NAME “Value Set”
,ATT.DISPLAY_FLAG “Displayed”
,ATT.ENABLED_FLAG “Enabled”
,ATT.REQUIRED_FLAG “Required”
FROM APPS.FND_DESCRIPTIVE_FLEXS_VL FFV
,APPS.FND_DESCR_FLEX_CONTEXTS_VL FFC
,APPS.FND_DESCR_FLEX_COL_USAGE_VL ATT
,APPS.FND_FLEX_VALUE_SETS FVS
,APPS.FND_APPLICATION_VL AP
WHERE FFV.DESCRIPTIVE_FLEXFIELD_NAME = ATT.DESCRIPTIVE_FLEXFIELD_NAME
AND AP.APPLICATION_ID = FFV.APPLICATION_ID
AND FFV.DESCRIPTIVE_FLEXFIELD_NAME = FFC.DESCRIPTIVE_FLEXFIELD_NAME
AND FFV.APPLICATION_ID = FFC.APPLICATION_ID
AND FFC.DESCRIPTIVE_FLEX_CONTEXT_CODE = ATT.DESCRIPTIVE_FLEX_CONTEXT_CODE
AND FVS.FLEX_VALUE_SET_ID = ATT.FLEX_VALUE_SET_ID
AND ATT.FORM_LEFT_PROMPT LIKE ‘Give Title Name’
ORDER BY ATT.COLUMN_SEQ_NUM
Conclusion
This query will be useful when you know only the window prompt.
