DBA Data[Home] [Help]

APPS.OZF_SCHEDULE_DENORM_PVT dependencies on HZ_RELATIONSHIPS

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 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