SELECT lookup_code list_id , meaning list_name FROM fnd_lookups WHERE lookup_type = 'BIX_DM_ALL_LOOKUP' UNION SELECT to_char(list_header_id) list_id , list_name list_name FROM AMS_list_headers_all
View Text - HTML Formatted
SELECT LOOKUP_CODE LIST_ID , MEANING LIST_NAME FROM FND_LOOKUPS WHERE LOOKUP_TYPE = 'BIX_DM_ALL_LOOKUP' UNION SELECT TO_CHAR(LIST_HEADER_ID) LIST_ID , LIST_NAME LIST_NAME FROM AMS_LIST_HEADERS_ALL