You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Get Work Order Details for a Service Request

in Fusion Service 2 comments

Hi

We have a requirement to get the Service Request details along with the associated work order detail in a report. A possible join can be the the SR Number and Work Order Number. But Work Order Number contains the line number along with the SR Number. So for a service request SR-87654 the work order number will be SR-87654.1-1. We are looking for exact join to get the SR Number and its associated work order details.

Tables

SVC_SERVICE_REQUESTS

WIE_WORK_ORDERS_B

Regards,

Zubair

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!