APPS.OZF_SCHEDULE_DENORM_PVT dependencies on HZ_PARTY_SITES

Line 47: hz_parties b, hz_party_sites ps,hz_locations f,

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

Line 48: hz_cust_acct_sites_all cs,hz_cust_site_uses_all cu,hz_locations hl, hz_party_sites hp

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
52: am.list_header_id is not null and

Line 452: hz_party_sites ps,hz_locations f,

448: s.activity_id, s.marketing_medium_id, ps.party_id,cs.cust_account_id,
449: cs.cust_acct_site_id, cu.site_use_id,cu.site_use_code,nvl(l_item_type,'ALLPRODUCTS') prod_indicator
450: FROM ams_campaign_schedules_vl s,
451: ams_campaigns_vl ct,
452: hz_party_sites ps,hz_locations f,
453: hz_cust_acct_sites_all cs,hz_cust_site_uses_all cu,hz_locations hl, hz_party_sites hp
454: WHERE
455: s.schedule_id = l_schedule_id
456: and ct.campaign_id = s.campaign_id

Line 453: hz_cust_acct_sites_all cs,hz_cust_site_uses_all cu,hz_locations hl, hz_party_sites hp

449: cs.cust_acct_site_id, cu.site_use_id,cu.site_use_code,nvl(l_item_type,'ALLPRODUCTS') prod_indicator
450: FROM ams_campaign_schedules_vl s,
451: ams_campaigns_vl ct,
452: hz_party_sites ps,hz_locations f,
453: hz_cust_acct_sites_all cs,hz_cust_site_uses_all cu,hz_locations hl, hz_party_sites hp
454: WHERE
455: s.schedule_id = l_schedule_id
456: and ct.campaign_id = s.campaign_id
457: and ps.party_id = l_party_id