VIEW: APPS.IEC_AVAILABLE_RECORDS_V

Source

View Text - Preformatted

SELECT o.campaign_id, e.campaign_name, o.SCHEDULE_ID, d.schedule_name, o.RECORD_AVAILABLE FROM ( SELECT c.campaign_id CAMPAIGN_ID, c.campaign_schedule_id SCHEDULE_ID, count(*) RECORD_AVAILABLE from iec_g_return_entries a , iec_g_mktg_item_cc_Tzs b , iec_g_list_rt_info c , iec_g_subset_rt_info f, iec_g_list_subsets g, AMS_CAMPAIGNS_ALL_b H where a.subset_id = b.subset_id and a.itm_cc_tz_id = b.itm_cc_tz_id and a.do_not_use_flag = 'N' and a.subset_id = f.list_subset_id and a.subset_id = g.list_subset_id and f.status_code = 'ACTIVE' and g.status_code = 'ACTIVE' and b.callable_flag = 'Y' and (a.callback_flag = 'N' or a.next_call_time < sysdate) and a.list_header_id = c.list_header_id and c.status_code = 'ACTIVE' and (c.release_strategy = 'QUA' or c.working_quota <> 0) and c.campaign_id = h.campaign_id and h.status_code = 'ACTIVE' group by c.campaign_id, c.campaign_schedule_id ) o, IEC_G_AO_LISTS_V d , IEC_G_CAMPAIGNS_V e WHERE o.campaign_id = e.campaign_id and o.schedule_id = d.schedule_id and d.campaign_id = e.campaign_id and d.language = USERENV('LANG') and e.language = USERENV('LANG')

View Text - HTML Formatted

SELECT O.CAMPAIGN_ID
, E.CAMPAIGN_NAME
, O.SCHEDULE_ID
, D.SCHEDULE_NAME
, O.RECORD_AVAILABLE
FROM ( SELECT C.CAMPAIGN_ID CAMPAIGN_ID
, C.CAMPAIGN_SCHEDULE_ID SCHEDULE_ID
, COUNT(*) RECORD_AVAILABLE
FROM IEC_G_RETURN_ENTRIES A
, IEC_G_MKTG_ITEM_CC_TZS B
, IEC_G_LIST_RT_INFO C
, IEC_G_SUBSET_RT_INFO F
, IEC_G_LIST_SUBSETS G
, AMS_CAMPAIGNS_ALL_B H
WHERE A.SUBSET_ID = B.SUBSET_ID
AND A.ITM_CC_TZ_ID = B.ITM_CC_TZ_ID
AND A.DO_NOT_USE_FLAG = 'N'
AND A.SUBSET_ID = F.LIST_SUBSET_ID
AND A.SUBSET_ID = G.LIST_SUBSET_ID
AND F.STATUS_CODE = 'ACTIVE'
AND G.STATUS_CODE = 'ACTIVE'
AND B.CALLABLE_FLAG = 'Y'
AND (A.CALLBACK_FLAG = 'N' OR A.NEXT_CALL_TIME < SYSDATE)
AND A.LIST_HEADER_ID = C.LIST_HEADER_ID
AND C.STATUS_CODE = 'ACTIVE'
AND (C.RELEASE_STRATEGY = 'QUA' OR C.WORKING_QUOTA <> 0)
AND C.CAMPAIGN_ID = H.CAMPAIGN_ID
AND H.STATUS_CODE = 'ACTIVE' GROUP BY C.CAMPAIGN_ID
, C.CAMPAIGN_SCHEDULE_ID ) O
, IEC_G_AO_LISTS_V D
, IEC_G_CAMPAIGNS_V E
WHERE O.CAMPAIGN_ID = E.CAMPAIGN_ID
AND O.SCHEDULE_ID = D.SCHEDULE_ID
AND D.CAMPAIGN_ID = E.CAMPAIGN_ID
AND D.LANGUAGE = USERENV('LANG')
AND E.LANGUAGE = USERENV('LANG')