APPS.CSF_RESOURCE_PUB dependencies on MTL_ITEM_CATEGORIES

Line 816: FROM mtl_item_categories mic

812: OR ts.skill_type_id = 3
813: AND rs.skill_id = ts.skill_id
814: AND ts.skill_type_id = rs.skill_type_id
815: AND EXISTS (SELECT 1
816: FROM mtl_item_categories mic
817: WHERE mic.category_id = rs.skill_id
818: AND category_set_id = fnd_profile.VALUE('CS_SR_DEFAULT_CATEGORY_SET'))
819: /* OR ts.skill_type_id = 2
820: AND rs.skill_type_id = 3

Line 823: , mtl_item_categories mic

819: /* OR ts.skill_type_id = 2
820: AND rs.skill_type_id = 3
821: AND NOT EXISTS (SELECT 1
822: FROM csf_required_skills_b ts2
823: , mtl_item_categories mic
824: WHERE NVL(ts2.disabled_flag, 'N') <> 'Y'
825: AND ts2.has_skill_type = ts.has_skill_type
826: AND ts2.has_skill_id = ts.has_skill_id
827: AND ts2.required_skill_id <> ts.required_skill_id

Line 840: FROM mtl_item_categories mic

836: AND rs2.resource_id = rs.resource_id
837: AND rs2.skill_id = ts.skill_id
838: AND rs2.skill_type_id = ts.skill_type_id)
839: AND EXISTS (SELECT category_id
840: FROM mtl_item_categories mic
841: WHERE mic.inventory_item_id = ts.skill_id
842: AND mic.category_set_id = fnd_profile.VALUE('CS_SR_DEFAULT_CATEGORY_SET')
843: AND mic.category_id = rs.skill_id) */
844: )