SELECT type_name FROM user_types WHERE typecode = 'COLLECTION';
SELECT * FROM user_source where type = 'TYPE' and name='TYP_KC_BE_THRESHOLD' ORDER BY line;
SELECT name, type FROM user_dependencies WHERE referenced_name='TYP_KC_BE_THRESHOLD';
SELECT * FROM user_source where type = 'TYPE' and name='TYP_KC_BE_THRESHOLD' ORDER BY line;
SELECT name, type FROM user_dependencies WHERE referenced_name='TYP_KC_BE_THRESHOLD';