APPS.CSF_RESOURCE_PUB dependencies on MTL_SYSTEM_ITEMS_KFV
Line 811: AND EXISTS (SELECT 1 FROM mtl_system_items_kfv msi WHERE msi.inventory_item_id = rs.skill_id)
807: AND TRUNC(NVL(ss.end_date_active, SYSDATE) + 1) > SYSDATE
808: OR ts.skill_type_id = 2
809: AND rs.skill_id = ts.skill_id
810: AND ts.skill_type_id = rs.skill_type_id 811: AND EXISTS (SELECT 1 FROM mtl_system_items_kfv msi WHERE msi.inventory_item_id = rs.skill_id) 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