VIEW: APPS.BIX_DM_CAMPAIGNS_PARAM_V

Source

View Text - Preformatted

SELECT lookup_code campaign_id , meaning campaign_name from fnd_lookups WHERE lookup_type = 'BIX_DM_ALL_LOOKUP' union select to_char(campaign_id) campaign_id , campaign_name campaign_name from ams_campaigns_vl order by campaign_name

View Text - HTML Formatted

SELECT LOOKUP_CODE CAMPAIGN_ID
, MEANING CAMPAIGN_NAME
FROM FND_LOOKUPS
WHERE LOOKUP_TYPE = 'BIX_DM_ALL_LOOKUP' UNION SELECT TO_CHAR(CAMPAIGN_ID) CAMPAIGN_ID
, CAMPAIGN_NAME CAMPAIGN_NAME
FROM AMS_CAMPAIGNS_VL ORDER BY CAMPAIGN_NAME