Query:

SELECT CONCATENATED_SEGS_VIEW_NAME,APPLICATION_TABLE_NAME,DESCRIPTIVE_FLEXFIELD_NAME,TITLE,CONTEXT_COLUMN_NAME,DESCRIPTION
FROM FND_DESCRIPTIVE_FLEXS_VL
WHERE APPLICATION_ID = 401 --Take Inventory Module as Example
ORDER BY APPLICATION_TABLE_NAME;

List:

CONCATENATED_SEGS_VIEW_NAME	APPLICATION_TABLE_NAME	DESCRIPTIVE_FLEXFIELD_NAME	TITLE	CONTEXT_COLUMN_NAME	DESCRIPTION
MTL_ABC_ASSIGNMENT_GROUPS_DFV	MTL_ABC_ASSIGNMENT_GROUPS	MTL_ABC_ASSIGNMENT_GROUPS	ABC groups	ATTRIBUTE_CATEGORY
MTL_ABC_COMPILE_HEADERS_DFV	MTL_ABC_COMPILE_HEADERS	MTL_ABC_COMPILE_HEADERS	ABC Analysis Compile Headers	ATTRIBUTE_CATEGORY	ABC Analysis Compile Headers - Generic Descriptive flex fields
MTL_ACTIONS_B_DFV	MTL_ACTIONS_B	MTL_ACTIONS	Maintain Actions	ATTRIBUTE_CATEGORY
MTL_ATP_RULES_DFV	MTL_ATP_RULES	MTL_ATP_RULES	ATP Computation Rules	ATTRIBUTE_CATEGORY	ATP Rules Flex Field
MTL_CATEGORIES_B_DFV	MTL_CATEGORIES_B	MTL_CATEGORIES	Item Categories	ATTRIBUTE_CATEGORY	Additional Item Category Information
MTL_CC_ENTRIES_INTERFACE_DFV	MTL_CC_ENTRIES_INTERFACE	Cycle Count Entries Interface	Cycle Count Entries Interface	ATTRIBUTE_CATEGORY
MTL_CC_SCHEDULE_REQUESTS_DFV	MTL_CC_SCHEDULE_REQUESTS	MTL_CC_SCHEDULE_REQUESTS	Schedule Requests	ATTRIBUTE_CATEGORY
MTL_COMMODITY_CODES_DFV	MTL_COMMODITY_CODES	MTL_COMMODITY_CODES	Customer Item Commodity Codes	ATTRIBUTE_CATEGORY	Customer Item Commodity Codes
MTL_CROSS_REFERENCES_DFV	MTL_CROSS_REFERENCES	MTL_CROSS_REFERENCES	Item cross-references	ATTRIBUTE_CATEGORY	Additional Item cross-reference information
MTL_CROSS_REFERENCE_TYPES_DFV	MTL_CROSS_REFERENCE_TYPES	MTL_CROSS_REFERENCE_TYPES	Item cross-reference types	ATTRIBUTE_CATEGORY
MTL_CUSTOMER_ITEMS_DFV	MTL_CUSTOMER_ITEMS	MTL_CUSTOMER_ITEMS	Customer Items	ATTRIBUTE_CATEGORY	Customer Items
MTL_CUSTOMER_ITEM_XREFS_DFV	MTL_CUSTOMER_ITEM_XREFS	MTL_CUSTOMER_ITEM_XREFS	Customer Item Cross References	ATTRIBUTE_CATEGORY	Customer Item Cross References
MTL_CYCLE_COUNT_ENTRIES_DFV	MTL_CYCLE_COUNT_ENTRIES	MTL_CYCLE_COUNT_ENTRIES	Cycle Count Entries	ATTRIBUTE_CATEGORY
MTL_CYCLE_COUNT_ENTRIES1_DFV	MTL_CYCLE_COUNT_ENTRIES	MTL_CC_ENTRIES_ADDITIONAL_INFO	Additional Cycle Count Entry Information	COUNT_DATE_CURRENT	Additional Cycle Count Entry Information
MTL_CYCLE_COUNT_ENTRIES2_DFV	MTL_CYCLE_COUNT_ENTRIES	MTL_CC_ENTRIES_LOT_NUMBER	Cycle Count Lot Number	LOT_CONTROL	Development dflex for lot number
MTL_CYCLE_COUNT_HEADERS_DFV	MTL_CYCLE_COUNT_HEADERS	MTL_CYCLE_COUNT_HEADERS	Cycle count headers	ATTRIBUTE_CATEGORY	Cycle count headers
MTL_DEMAND_DFV	MTL_DEMAND	MTL_DEMAND	Item reservations	ATTRIBUTE_CATEGORY
MTL_DEMAND_INTERFACE_DFV	MTL_DEMAND_INTERFACE	MTL_DEMAND_INTERFACE	Demand interface	ATTRIBUTE_CATEGORY
MTL_EAM_ASSET_ACTIVITIES_DFV	MTL_EAM_ASSET_ACTIVITIES	MTL_EAM_ASSET_ACTIVITIES	Asset Activity Association	ATTRIBUTE_CATEGORY	MTL_EAM_ASSET_ACTIVITIES
MTL_EAM_ASSET_ATTR_VALUES_DFV	MTL_EAM_ASSET_ATTR_VALUES	MTL_EAM_ASSET_ATTR_VALUES	Asset Attributes	ATTRIBUTE_CATEGORY	MTL_EAM_ASSET_ATTR_VALUES
MTL_EAM_NETWORK_ASSETS_DFV	MTL_EAM_NETWORK_ASSETS	MTL_EAM_NETWORK_ASSETS	Asset Routes Association	ATTRIBUTE_CATEGORY	MTL_EAM_NETWORK_ASSETS
MTL_GENERIC_DISPOSITIONS_DFV	MTL_GENERIC_DISPOSITIONS	MTL_GENERIC_DISPOSITIONS	Account aliases	ATTRIBUTE_CATEGORY
MTL_GRADES_B_DFV	MTL_GRADES_B	MTL_GRADES	Maintain Grades	ATTRIBUTE_CATEGORY
MTL_INTERCOMPANY_PARAMETER_DFV	MTL_INTERCOMPANY_PARAMETERS	MTL_INTERCOMPANY_PARAMETERS	Intercompany relations	ATTRIBUTE_CATEGORY	Intercompany relations
MTL_INTERORG_PARAMETERS_DFV	MTL_INTERORG_PARAMETERS	MTL_INTERORG_PARAMETERS	Inter-organization parameters	ATTRIBUTE_CATEGORY	Inter-organization parameters
MTL_INTERORG_SHIP_METHODS_DFV	MTL_INTERORG_SHIP_METHODS	MTL_INTERORG_SHIP_METHODS	Additional Info For Inter-Org Ship Method	ATTRIBUTE_CATEGORY
MTL_ITEM_CATALOG_GROUPS_B_DFV	MTL_ITEM_CATALOG_GROUPS_B	MTL_ITEM_CATALOG_GROUPS	Item Catalog Groups	ATTRIBUTE_CATEGORY	Item Catalog Groups
MTL_ITEM_LOCATIONS_DFV	MTL_ITEM_LOCATIONS	MTL_ITEM_LOCATIONS	Stock locators	ATTRIBUTE_CATEGORY
MTL_ITEM_REVISIONS_B_DFV	MTL_ITEM_REVISIONS_B	MTL_ITEM_REVISIONS	Item Revisions	ATTRIBUTE_CATEGORY	Item Revisions
MTL_ITEM_STATUS_DFV	MTL_ITEM_STATUS_TL	MTL_ITEM_STATUS	Item status	ATTRIBUTE_CATEGORY
MTL_ITEM_SUB_INVENTORIES_DFV	MTL_ITEM_SUB_INVENTORIES	MTL_ITEM_SUB_INVENTORIES	Item Subinventories	ATTRIBUTE_CATEGORY
MTL_ITEM_TEMPLATES_DFV	MTL_ITEM_TEMPLATES_B	MTL_ITEM_TEMPLATES	Item Template Descriptive Flexfield	ATTRIBUTE_CATEGORY	Item Template Descriptive Flexfield
MTL_KANBAN_CARDS_DFV	MTL_KANBAN_CARDS	MTL_KANBAN_CARDS	Kanban Cards	ATTRIBUTE_CATEGORY
MTL_KANBAN_CARD_ACTIVITY_DFV	MTL_KANBAN_CARD_ACTIVITY	MTL_KANBAN_CARD_ACTIVITY	Kanban Card Activity	ATTRIBUTE_CATEGORY
MTL_KANBAN_PULL_SEQUENCES_DFV	MTL_KANBAN_PULL_SEQUENCES	MTL_KANBAN_PULL_SEQUENCES	Pull Sequences	ATTRIBUTE_CATEGORY
MTL_LOT_NUMBERS_DFV	MTL_LOT_NUMBERS	MTL_LOT_NUMBERS	Maintain Lot Numbers	ATTRIBUTE_CATEGORY
MTL_LOT_NUMBERS1_DFV	MTL_LOT_NUMBERS	Lot Attributes	Lot Attributes	LOT_ATTRIBUTE_CATEGORY	Lot Attributes Descriptive Flex field
MTL_MANUFACTURERS_DFV	MTL_MANUFACTURERS	MTL_MANUFACTURERS	Manufacturers	ATTRIBUTE_CATEGORY
MTL_MATERIAL_TRANSACTIONS_DFV	MTL_MATERIAL_TRANSACTIONS	MTL_MATERIAL_TRANSACTIONS	Transaction history	ATTRIBUTE_CATEGORY
MTL_MFG_PART_NUMBERS_DFV	MTL_MFG_PART_NUMBERS	MTL_MFG_PART_NUMBERS	Manufacturer Part Number	ATTRIBUTE_CATEGORY
MTL_MOVEMENT_PARAMETERS_DFV	MTL_MOVEMENT_PARAMETERS	MTL_MOVEMENT_PARAMETERS	Movement Parameters	ATTRIBUTE_CATEGORY	Movement Parameters
MTL_MOVEMENT_STATISTICS_DFV	MTL_MOVEMENT_STATISTICS	MTL_MOVEMENT_STATISTICS	Movement Statistics	ATTRIBUTE_CATEGORY	Movement Statistics
MTL_PARAMETERS_DFV	MTL_PARAMETERS	MTL_PARAMETERS	Organization parameters	ATTRIBUTE_CATEGORY
MTL_PHYSICAL_ADJUSTMENTS_DFV	MTL_PHYSICAL_ADJUSTMENTS	MTL_PHYSICAL_ADJUSTMENTS	Additional Item/Adjustment Information	LOT_SERIAL_CONTROLS	Additional Item/Adjustment Information
MTL_PHYSICAL_INVENTORIES_DFV	MTL_PHYSICAL_INVENTORIES	MTL_PHYSICAL_INVENTORIES	Physical Inventory	ATTRIBUTE_CATEGORY
MTL_PHYSICAL_INVENTORY_TA1_DFV	MTL_PHYSICAL_INVENTORY_TAGS	MTL_PHYSICAL_TAGS_LOT_SERIAL	Lot/Serial Number Information	LOT_SERIAL_CONTROLS	Additional Tag information
MTL_PHYSICAL_INVENTORY_TAG_DFV	MTL_PHYSICAL_INVENTORY_TAGS	MTL_PHYSICAL_INVENTORY_TAGS	Physical inventory tags	ATTRIBUTE_CATEGORY
MTL_PLANNERS_DFV	MTL_PLANNERS	MTL_PLANNERS	Planners	ATTRIBUTE_CATEGORY
MTL_RELATED_ITEMS_DFV	MTL_RELATED_ITEMS	MTL_RELATED_ITEMS	Item Relationships	ATTR_CONTEXT	Item Relationships Descriptive Flexfield
MTL_RESERVATIONS_DFV	MTL_RESERVATIONS	MTL_RESERVATIONS	Reservations	ATTRIBUTE_CATEGORY	Reservations descriptive flex
MTL_RESERVATIONS_INTERFACE_DFV	MTL_RESERVATIONS_INTERFACE	MTL_RESERVATIONS_INTERFACE	Reservations Interface	ATTRIBUTE_CATEGORY
MTL_RTG_ITEM_REVISIONS_DFV	MTL_RTG_ITEM_REVISIONS	MTL_RTG_ITEM_REVISIONS	Routing revisions	ATTRIBUTE_CATEGORY
MTL_SECONDARY_INVENTORIES_DFV	MTL_SECONDARY_INVENTORIES	MTL_SECONDARY_INVENTORIES	Subinventories	ATTRIBUTE_CATEGORY
MTL_SERIAL_NUMBERS1_DFV	MTL_SERIAL_NUMBERS	Serial Attributes	Serial Attributes	SERIAL_ATTRIBUTE_CATEGORY	Serial Attributes
MTL_SERIAL_NUMBERS_DFV	MTL_SERIAL_NUMBERS	MTL_SERIAL_NUMBERS	Serial numbers	ATTRIBUTE_CATEGORY
MTL_SHORT_CHK_PARAM_DFV	MTL_SHORT_CHK_PARAM	MTL_SHORT_CHK_PARAM	Shortage Parameter	ATTRIBUTE_CATEGORY	Shortage Parameter Descriptive Flexfield
MTL_SYSTEM_ITEMS_B_DFV	MTL_SYSTEM_ITEMS_B	MTL_SYSTEM_ITEMS	Items	ATTRIBUTE_CATEGORY
MTL_TRANSACTIONS_INTERFACE_DFV	MTL_TRANSACTIONS_INTERFACE	MTL_TRANSACTIONS_INTERFACE	Transaction interface	ATTRIBUTE_CATEGORY
MTL_TRANSACTION_FLOW_HEADE_DFV	MTL_TRANSACTION_FLOW_HEADERS	MTL_TXN_FLOW_HEADERS_DFF	Transaction Flow Headers DFF	ATTRIBUTE_CATEGORY	Desc Flex for Trx Flow Header
MTL_TRANSACTION_FLOW_LINES_DFV	MTL_TRANSACTION_FLOW_LINES	MTL_TXN_FLOW_LINES_DFF	Transaction Flow Lines DFF	ATTRIBUTE_CATEGORY	Desc Flex for Trx flow Lines
MTL_TRANSACTION_REASONS_DFV	MTL_TRANSACTION_REASONS	MTL_TRANSACTION_REASONS	Transaction Reasons	ATTRIBUTE_CATEGORY	Transaction Reasons
MTL_TRANSACTION_TYPES_DFV	MTL_TRANSACTION_TYPES	MTL_TRANSACTION_TYPES	Transaction types	ATTRIBUTE_CATEGORY
MTL_TXN_REQUEST_HEADERS_DFV	MTL_TXN_REQUEST_HEADERS	MTL_TXN_REQUEST_HEADERS	Transfer Order Header	ATTRIBUTE_CATEGORY	Transfer Order Header
MTL_TXN_REQUEST_LINES_DFV	MTL_TXN_REQUEST_LINES	MTL_TXN_REQUEST_LINES	Transfer Order Lines	ATTRIBUTE_CATEGORY
MTL_TXN_SOURCE_TYPES_DFV	MTL_TXN_SOURCE_TYPES	MTL_TXN_SOURCE_TYPES	Transaction source types	ATTRIBUTE_CATEGORY	MTL_TXN_SOURCE_TYPES
MTL_TXN_SOURCE_TYPES1_DFV	MTL_TXN_SOURCE_TYPES	Transaction Source	Transaction Source	TRANSACTION_SOURCE_CATEGORY	Transaction Source Validation Descriptive Flex
MTL_UNITS_OF_MEASURE_TL_DFV	MTL_UNITS_OF_MEASURE_TL	MTL_UNITS_OF_MEASURE	Define Unit of Measure	ATTRIBUTE_CATEGORY
MTL_UOM_CLASSES_TL_DFV	MTL_UOM_CLASSES_TL	MTL_UOM_CLASSES	Unit of measure classes	ATTRIBUTE_CATEGORY
ORG_FREIGHT_TL_DFV	ORG_FREIGHT_TL	ORG_FREIGHT	Freight carriers	ATTRIBUTE_CATEGORY

Descriptive Flex Field List