APPS.CSF_GANTT_DATA_PKG dependencies on MTL_SYSTEM_ITEMS_KFV

Line 349: FROM cs_incidents_all_b i, mtl_system_items_kfv si

345: SELECT /*+ ORDERED USE_NL */
346: i.customer_product_id
347: , i.current_serial_number
348: , si.concatenated_segments product_name
349: FROM cs_incidents_all_b i, mtl_system_items_kfv si
350: WHERE si.inventory_item_id(+) = i.inventory_item_id
351: AND si.organization_id(+) = i.inv_organization_id
352: AND i.incident_id = b_incident_id;
353:

Line 1489: FROM cs_incidents_all_b i, mtl_system_items_kfv si

1485: SELECT /*+ ORDERED USE_NL */
1486: i.customer_product_id
1487: , i.current_serial_number
1488: , si.concatenated_segments product_name
1489: FROM cs_incidents_all_b i, mtl_system_items_kfv si
1490: WHERE si.inventory_item_id(+) = i.inventory_item_id
1491: AND si.organization_id(+) = i.inv_organization_id
1492: AND i.incident_id = b_incident_id;
1493:

Line 2459: FROM cs_incidents_all_b i, mtl_system_items_kfv si

2455: SELECT /*+ ORDERED USE_NL */
2456: i.customer_product_id
2457: , i.current_serial_number
2458: , si.concatenated_segments product_name
2459: FROM cs_incidents_all_b i, mtl_system_items_kfv si
2460: WHERE si.inventory_item_id(+) = i.inventory_item_id
2461: AND si.organization_id(+) = i.inv_organization_id
2462: AND i.incident_id = b_incident_id;
2463:

Line 3186: FROM cs_incidents_all_b i, mtl_system_items_kfv si

3182: SELECT /*+ ORDERED USE_NL */
3183: i.customer_product_id
3184: , i.current_serial_number
3185: , si.concatenated_segments product_name
3186: FROM cs_incidents_all_b i, mtl_system_items_kfv si
3187: WHERE si.inventory_item_id(+) = i.inventory_item_id
3188: AND si.organization_id(+) = i.inv_organization_id
3189: AND i.incident_id = b_incident_id;
3190:

Line 4480: AND EXISTS (SELECT 1 FROM mtl_system_items_kfv msi WHERE msi.inventory_item_id = rs.skill_id)

4476: AND TRUNC(NVL(ss.end_date_active, SYSDATE) + 1) > SYSDATE
4477: OR ts.skill_type_id = 2
4478: AND rs.skill_id = ts.skill_id
4479: AND ts.skill_type_id = rs.skill_type_id
4480: AND EXISTS (SELECT 1 FROM mtl_system_items_kfv msi WHERE msi.inventory_item_id = rs.skill_id)
4481: OR ts.skill_type_id = 3
4482: AND rs.skill_id = ts.skill_id
4483: AND ts.skill_type_id = rs.skill_type_id
4484: AND EXISTS (SELECT 1