I am trying to make a report that will pull any RMA with a status of closed (03) where the associated/attached RTV has a status of anything other than closed (40).
Can someone help me to identify the correct tables.
Thanks
*This post is locked for comments
I think this will do it:
select *
from SVC35000 r
inner join SVC05501 t
on r.RETTYPE = t.RETTYPE
inner join SVC35200 l
on r.RETDOCID = l.RETDOCID
and r.Return_Record_Type = l.Return_Record_Type
inner join SVC35210 p
on l.RETDOCID = p.RETDOCID
and l.Return_Record_Type = p.Return_Record_Type
and l.LNSEQNBR = p.LNSEQNBR
inner join
(
select RTV_Number, RTV_Type, RTV_Return_Status
from SVC05600
union all
select RTV_Number, RTV_Type, RTV_Return_Status
from SVC35600
) rtv
on p.SVC_Document_Number = rtv.RTV_Number
inner join SVC05003 rtvt
on rtv.RTV_Type = rtvt.RTV_Type
where r.RETSTAT = t.Close_Status
and rtv.RTV_Return_Status <> RTV_Closed_Status
and p.SVC_Process_Type = 2
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
