DBA Data[Home] [Help]

VIEW: APPS.BIX_DM_SITE_PARAM_V

Source

View Text - Preformatted

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
View Text - HTML Formatted

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