APPS.JTF_RS_RESOURCE_SKILLS_PUB dependencies on MTL_ITEM_CATEGORIES

Line 311: FROM mtl_item_categories c

307: FROM jtf_rs_resource_skills a
308: WHERE resource_id = p_resource_id
309: AND ((category_id is null and
310: exists (SELECT null
311: FROM mtl_item_categories c
312: WHERE a.product_id = c.inventory_item_id
313: AND c.organization_id = a.product_org_id
314: AND c.category_id = p_category_id)) OR
315: category_id = p_category_id)

Line 424: FROM mtl_item_categories c

420: FROM jtf_rs_products_v a
421: WHERE a.product_org_id = p_product_org_id
422: AND nvl(a.enabled_flag, 'Y') <> 'N'
423: AND EXISTS(SELECT null
424: FROM mtl_item_categories c
425: WHERE a.product_id = c.inventory_item_id
426: AND c.organization_id = p_product_org_id
427: AND c.category_id = p_category_id)
428: AND NOT EXISTS (SELECT null