DBA Data[Home] [Help]

APPS.OZF_SCHEDULE_DENORM_PVT dependencies on MTL_ITEM_CATEGORIES

Line 194: mtl_item_categories mtl,

190: ozf_activity_hl_denorm am,
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

Line 432: mtl_item_categories mtl,

428: a.source_code,a.start_date,a.end_date,a.owner_id,mtl.inventory_item_id item,'PRODUCT' item_type, a.activity_type_code,
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

Line 535: mtl_item_categories mtl,

531: decode(l_list_header_id,null,'ALLCUSTOMERS','CUSTOMERS') cust_indicator
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