DBA Data[Home] [Help]

APPS.OZF_SCHEDULE_DENORM_PVT dependencies on ENI_PROD_DENORM_HRCHY_V

Line 195: eni_prod_denorm_hrchy_v eni

191: ams_campaign_schedules_vl s,
192: ams_campaigns_vl ct,
193: ams_act_products ap,
194: mtl_item_categories mtl,
195: eni_prod_denorm_hrchy_v eni
196: WHERE
197: am.schedule_id = s.schedule_id
198: and ct.campaign_id = s.campaign_id
199: and ap.act_product_used_by_id = s.schedule_id

Line 433: eni_prod_denorm_hrchy_v eni

429: a.activity_id, a.marketing_medium_id, a.cust_indicator
430: FROM ozf_activity_products a,
431: ozf_activity_hl_denorm b,
432: mtl_item_categories mtl,
433: eni_prod_denorm_hrchy_v eni
434: WHERE b.product_update_date > l_latest_comp_date
435: and b.item_type = 'FAMILY'
436: and a.object_id = b.schedule_id
437: and a.object_class = 'CSCH'

Line 536: eni_prod_denorm_hrchy_v eni

532: FROM ams_campaign_schedules_vl s,
533: ams_campaigns_vl ct,
534: ams_act_products ap,
535: mtl_item_categories mtl,
536: eni_prod_denorm_hrchy_v eni
537: WHERE
538: s.schedule_id = l_schedule_id AND
539: ct.campaign_id = s.campaign_id AND
540: ap.act_product_used_by_id = s.schedule_id AND