SELECT a.column_name field_name, b.lookup_code source_type_code from all_tab_columns a, iec_lookups b WHERE b.lookup_type='IEC_SOURCE_VIEW_MAP' and a.table_name = b.tag and a.owner = 'APPS'
View Text - HTML Formatted
SELECT A.COLUMN_NAME FIELD_NAME , B.LOOKUP_CODE SOURCE_TYPE_CODE FROM ALL_TAB_COLUMNS A , IEC_LOOKUPS B WHERE B.LOOKUP_TYPE='IEC_SOURCE_VIEW_MAP' AND A.TABLE_NAME = B.TAG AND A.OWNER = 'APPS'