DBA Data[Home] [Help]

VIEW: APPS.BIX_DM_CAMP_SCHE_PARAM_V

Source

View Text - Preformatted

SELECT lookup_code camp_sche_id , meaning camp_sche_name FROM fnd_lookups WHERE lookup_type = 'BIX_DM_ALL_LOOKUP' UNION SELECT to_char(schedule_id) camp_sche_id , schedule_name camp_sche_name FROM AMS_CAMPAIGN_SCHEDULES_VL
View Text - HTML Formatted

SELECT LOOKUP_CODE CAMP_SCHE_ID
, MEANING CAMP_SCHE_NAME
FROM FND_LOOKUPS
WHERE LOOKUP_TYPE = 'BIX_DM_ALL_LOOKUP' UNION SELECT TO_CHAR(SCHEDULE_ID) CAMP_SCHE_ID
, SCHEDULE_NAME CAMP_SCHE_NAME
FROM AMS_CAMPAIGN_SCHEDULES_VL