APPS.CSF_RESOURCE_PUB dependencies on MTL_SYSTEM_ITEMS_KFV
Line 676: FROM mtl_system_items_kfv msi
672: AND TRUNC(ss.start_date_active) < p_end
673: AND (TRUNC(ss.end_date_active + 1) > p_start OR ss.end_date_active IS NULL)
674: )
675: OR EXISTS(SELECT 1 676: FROM mtl_system_items_kfv msi 677: WHERE msi.inventory_item_id = ts.skill_id)
678: )
679: GROUP BY rs.resource_id, rs.resource_type) rs
680: , (SELECT COUNT(*) amount