[Home] [Help]
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
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
|
|
|
|