eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_SCHEDULE_DENORM_PVT dependencies on HZ_CUST_SITE_USES_ALL

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 100: hz_cust_acct_sites_all cs,hz_cust_site_uses_all cu, hz_relationships hr

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

Line 147: hz_cust_acct_sites_all cs,hz_cust_site_uses_all cu

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
151: and le.list_header_id = am.list_header_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

Line 478: hz_cust_acct_sites_all cs,hz_cust_site_uses_all cu, hz_relationships hr

474: cs.cust_acct_site_id, cu.site_use_id,cu.site_use_code,nvl(l_item_type,'ALLPRODUCTS') prod_indicator
475: FROM ams_campaign_schedules_vl s,
476: ams_campaigns_vl ct,
477: hz_cust_accounts ca,
478: hz_cust_acct_sites_all cs,hz_cust_site_uses_all cu, hz_relationships hr
479: WHERE
480: s.schedule_id = l_schedule_id
481: and ct.campaign_id = s.campaign_id
482: and hr.party_id = l_party_id

Line 498: hz_cust_acct_sites_all cs,hz_cust_site_uses_all cu

494: cs.cust_acct_site_id, cu.site_use_id,cu.site_use_code,nvl(l_item_type,'ALLPRODUCTS') prod_indicator
495: FROM ams_campaign_schedules_vl s,
496: ams_campaigns_vl ct,
497: hz_cust_accounts ca,
498: hz_cust_acct_sites_all cs,hz_cust_site_uses_all cu
499: WHERE
500: s.schedule_id = l_schedule_id
501: and ct.campaign_id = s.campaign_id
502: and ca.party_id = l_party_id