SELECT fdf.DESCRIPTIVE_FLEXFIELD_NAME
,fdf.*
FROM apps.FND_DESCRIPTIVE_FLEXS_VL fdf
WHERE fdf.APPLICATION_TABLE_NAME = 'MTL_SYSTEM_ITEMS_B';
SELECT *
FROM apps.FND_DESCR_FLEX_COL_USAGE_TL f
WHERE f.DESCRIPTIVE_FLEXFIELD_NAME IN ('MTL_SYSTEM_ITEMS',
'BOM_ITEM_ORDER_ATTRIBUTES',
'BOM_ITEM_SHIPPING_ATTRIBUTES',
'JG_MTL_SYSTEM_ITEMS');