VIEW: APPS.IEC_BLNDG_SCH_REC_COUNT_V

Source

View Text - Preformatted

SELECT b.schedule_id, c.schedule_name, sum(a.record_count) AVAILABLE_COUNT from iec_g_mktg_item_cc_tzs a, iec_g_executing_lists_v b, ams_campaign_schedules_vl c WHERE a.campaign_schedule_id = + b.schedule_id AND a.campaign_schedule_id = c.schedule_id AND b.schedule_id = c.schedule_id AND a.last_callable_time > sysdate AND a.callable_flag= 'Y' group by b.schedule_id, c.schedule_name

View Text - HTML Formatted

SELECT B.SCHEDULE_ID
, C.SCHEDULE_NAME
, SUM(A.RECORD_COUNT) AVAILABLE_COUNT
FROM IEC_G_MKTG_ITEM_CC_TZS A
, IEC_G_EXECUTING_LISTS_V B
, AMS_CAMPAIGN_SCHEDULES_VL C
WHERE A.CAMPAIGN_SCHEDULE_ID = + B.SCHEDULE_ID
AND A.CAMPAIGN_SCHEDULE_ID = C.SCHEDULE_ID
AND B.SCHEDULE_ID = C.SCHEDULE_ID
AND A.LAST_CALLABLE_TIME > SYSDATE
AND A.CALLABLE_FLAG= 'Y' GROUP BY B.SCHEDULE_ID
, C.SCHEDULE_NAME