APPS.AMS_CAMPAIGN_ITEMS_DENORM_PVT dependencies on AMS_ACT_PRODUCTS

Line 19: FROM ams_act_products a,

15:
16: SELECT inventory_item_id, organization_id, category_id,
17: category_set_id, act_product_used_by_id,
18: arc_act_product_used_by
19: FROM ams_act_products a,
20: ams_campaign_schedules_b b
21: WHERE a.act_product_used_by_id = b.schedule_id
22: AND b.activity_type_code = 'INTERNET'
23: AND b.status_code = 'ACTIVE'