APPS.JTF_RS_RESOURCE_SKILLS_PVT dependencies on MTL_ITEM_CATEGORIES

Line 149: AND EXISTS ( SELECT null FROM MTL_ITEM_CATEGORIES c

145: FROM JTF_RS_PRODUCTS_V p
146: WHERE p.product_id = lpco_product_id
147: AND p.product_org_id = lpco_product_org_id
148: AND p.enabled_flag = 'Y'
149: AND EXISTS ( SELECT null FROM MTL_ITEM_CATEGORIES c
150: WHERE p.product_id = c.inventory_item_id
151: AND p.product_org_id = c.organization_id
152: AND c.category_id = lpco_category_id) ;
153: