DBA Data[Home] [Help]

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