DBA Data[Home] [Help]

VIEW: APPS.BIX_DM_DNIS_PARAM_V

Source

View Text - Preformatted

SELECT 1 sort_col, lookup_code dnis_id , meaning dnis_name from fnd_lookups WHERE lookup_type = 'BIX_DM_ALL_LOOKUP' union select 2 sort_col, to_char(dnis_id) dnis_id, dnis dnis_name from bix_dm_dnis
View Text - HTML Formatted

SELECT 1 SORT_COL
, LOOKUP_CODE DNIS_ID
, MEANING DNIS_NAME
FROM FND_LOOKUPS
WHERE LOOKUP_TYPE = 'BIX_DM_ALL_LOOKUP' UNION SELECT 2 SORT_COL
, TO_CHAR(DNIS_ID) DNIS_ID
, DNIS DNIS_NAME
FROM BIX_DM_DNIS