[Home] [Help]
43: FROM ams_campaign_schedules_vl s,
44: ozf_activity_hl_denorm am,
45: ams_campaigns_vl ct,
46: ams_list_entries le,
47: hz_parties b, hz_party_sites ps,hz_locations f,
48: hz_cust_acct_sites_all cs,hz_cust_site_uses_all cu,hz_locations hl, hz_party_sites hp
49: WHERE
50: s.schedule_id = am.schedule_id and
51: ct.campaign_id = s.campaign_id and
95: FROM ozf_activity_hl_denorm am,
96: ams_campaign_schedules_vl s,
97: ams_campaigns_vl ct,
98: ams_list_entries le,
99: hz_parties b, hz_cust_accounts ca,
100: hz_cust_acct_sites_all cs,hz_cust_site_uses_all cu, hz_relationships hr
101: WHERE
102: s.schedule_id = am.schedule_id
103: and ct.campaign_id = s.campaign_id
142: FROM ozf_activity_hl_denorm am,
143: ams_campaign_schedules_vl s,
144: ams_campaigns_vl ct,
145: ams_list_entries le,
146: hz_parties b, hz_cust_accounts ca,
147: hz_cust_acct_sites_all cs,hz_cust_site_uses_all cu
148: WHERE
149: am.schedule_id = s.schedule_id
150: and ct.campaign_id = s.campaign_id
363:
364: CURSOR c_new_schedules_cust(l_latest_comp_date DATE) IS
365: SELECT DISTINCT am.Schedule_Id,am.Campaign_id,am.Campaign_status,am.Campaign_class,am.Campaign_type,
366: am.Campaign_name,am.List_header_id,am.confidential_flag,am.item, am.item_type, b.party_id, b.party_type
367: FROM ozf_activity_hl_denorm am, ams_list_entries le, hz_parties b
368: WHERE am.schedule_update_date > l_latest_comp_date
369: AND am.list_header_id is not null
370: AND le.list_header_id = am.list_header_id
371: AND le.party_id = b.party_id;