SELECT 1 sort_col , lookup_code site_id , meaning site_name from fnd_lookups WHERE lookup_type = 'BIX_DM_ALL_LOOKUP' union select 2 sort_col , to_char(server_group_id) site_id , group_name site_name from ieo_svr_groups
SELECT 1 SORT_COL
, LOOKUP_CODE SITE_ID
, MEANING SITE_NAME
FROM FND_LOOKUPS
WHERE LOOKUP_TYPE = 'BIX_DM_ALL_LOOKUP' UNION SELECT 2 SORT_COL
, TO_CHAR(SERVER_GROUP_ID) SITE_ID
, GROUP_NAME SITE_NAME
FROM IEO_SVR_GROUPS
|
|
|