APPS.AMS_CAMPAIGN_ITEMS_DENORM_PVT dependencies on MTL_ITEM_CATEGORIES
Line 95: FROM mtl_item_categories a
91: SYSDATE,
92: FND_GLOBAL.user_id,
93: SYSDATE,
94: FND_GLOBAL.conc_login_id 95: FROM mtl_item_categories a 96: WHERE category_id = SchedItem.category_id
97: AND NOT EXISTS
98: (select 'x' from ams_iba_cpn_items_denorm
99: where item_id = a.inventory_item_id