DBA Data[Home] [Help]

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