DBA Data[Home] [Help]

APPS.CSF_GANTT_DATA_PKG dependencies on CS_INCIDENTS_ALL_B

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: