VIEW: APPS.BIX_BIS_DNIS_V

Source

View Text - Preformatted

SELECT lookup_code id, meaning value from fnd_lookup_values_vl vl where lookup_type = 'BIX_PMV_AI_DNISTYPES' UNION ALL select dnis id, dnis value from bix_dm_dnis where dnis <> 'OUTBOUND'

View Text - HTML Formatted

SELECT LOOKUP_CODE ID
, MEANING VALUE
FROM FND_LOOKUP_VALUES_VL VL
WHERE LOOKUP_TYPE = 'BIX_PMV_AI_DNISTYPES' UNION ALL SELECT DNIS ID
, DNIS VALUE
FROM BIX_DM_DNIS
WHERE DNIS <> 'OUTBOUND'