Searching by part ID for RMA's

unknown

Hi,

How do you search for RMA's by Part ID?  It is not available to search for in the RMA search filters, even though it is clearly in the line detail of the RMA.  So I tried writing a query to associate the CO table with the CO from the RMA table but that just gives me bad data and I cant seem to filter out the bad data.

So, does anyone have a query where you can show all RMA's for a given part number?  What am I missing?

 

Thank you,

Paul

mseppanen

You need to join up the RMA to the RMA_LINE and then you can join up the Customer Order Line, which has the part ID information.



You can then start winnowing out the columns, but here's the query for you.





-- ****************************************************************

-- Search for RMA's by Part ID

-- Replace 'Your PartID Here' with your actual part ID's

-- ****************************************************************



Select *

From RMA R

INNER JOIN RMA_LINE RL ON RL.RMA_ID = R.ID

INNER JOIN CUST_ORDER_LINE CL ON CL.CUST_ORDER_ID = R.ORG_CUST_ORDER_ID

AND RL.ORG_ORDER_LINE_NO = CL.LINE_NO



Where CL.PART_ID LIKE 'Your PartID Here'

OR CL.CUSTOMER_PART_ID LIKE 'Your PartID Here'



-- ****************************************************************

-- ****************************************************************