DBA Data[Home] [Help]

VIEW: APPS.BIX_DM_LIST_PARAM_V

Source

View Text - Preformatted

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