DBA Data[Home] [Help]

APPS.CSF_GANTT_DATA_PKG dependencies on CS_INCIDENTS_ALL_B

Line 294: FROM cs_incidents_all_b i, mtl_system_items_kfv si

290: SELECT /*+ ORDERED USE_NL */
291: i.customer_product_id
292: , i.current_serial_number
293: , si.concatenated_segments product_name
294: FROM cs_incidents_all_b i, mtl_system_items_kfv si
295: WHERE si.inventory_item_id(+) = i.inventory_item_id
296: AND si.organization_id(+) = i.inv_organization_id
297: AND i.incident_id = b_incident_id;
298:

Line 879: FROM cs_incidents_all_b i, mtl_system_items_kfv si

875: SELECT /*+ ORDERED USE_NL */
876: i.customer_product_id
877: , i.current_serial_number
878: , si.concatenated_segments product_name
879: FROM cs_incidents_all_b i, mtl_system_items_kfv si
880: WHERE si.inventory_item_id(+) = i.inventory_item_id
881: AND si.organization_id(+) = i.inv_organization_id
882: AND i.incident_id = b_incident_id;
883: