DBA Data[Home] [Help]

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