DBA Data[Home] [Help]

APPS.CSF_REQUIRED_SKILLS_PKG dependencies on CS_INCIDENTS_ALL_B

Line 336: , cs_incidents_all_b sr

332:
333: Cursor c_ProdSkill is
334: select mtl.inventory_item_id
335: from jtf_tasks_b tb
336: , cs_incidents_all_b sr
337: , mtl_system_items_kfv mtl
338: where mtl.organization_id = fnd_profile.value('CSF_INVENTORY_ORG')
339: and sysdate between nvl(mtl.start_date_active,sysdate) and nvl(mtl.end_date_active,sysdate)
340: and mtl.inventory_item_id = sr.inventory_item_id

Line 351: cs_incidents_all_b sr,

347: FROM mtl_category_set_valid_cats ic,
348: mtl_categories_kfv c,
349: mtl_category_sets_vl cs,
350: mtl_categories_tl t,
351: cs_incidents_all_b sr,
352: jtf_tasks_b tb
353: WHERE ic.category_id = c.category_id
354: AND t.category_id (+) = c.category_id
355: AND t.language (+) = userenv('LANG')