Component Part on Subject tab in Create Service Request has no values

We are implementing the Field Srvice module and have had progressed well with a few issues.

Current issue is the Component Part on the Subject tab in Create Service Request has no values.

Open an SR with Oracle Support and have done an SQL they suggested and have found the following issue with the results of the query.

The SQL:

select concatenated_segments  component, sr_comp.description, revision, component_id
from cs_sr_inv_components_v sr_comp, mtl_item_revisions rev
where sr_comp.component_id = rev.inventory_item_id
and sr_comp.organization_id = rev.organization_id
and sr_comp.inventory_item_id = 116889