Remote Complex Object Instance Service - AddItem Method - Prod Item Id Input

Dear All,

I have a requirement to add a service to the Order -> Line Item using the Remote Complex Object Instance Service and Add Item Method.

I have managed to run a script and find out the Port Id required. (lets say the port id of the service "B" which will be added under the root "A"). 

But i could not see a way of finding out the "Prod Item Id".

Can someone help with a sql to find out this?

Thanks in advance.

Regards

MJ