SQL

SELECT 
NH.USER1,
NR.INV_RECVLN_STATUS,
NT.INV_ITEM_ID
 
FROM PS_TRANSACTION_INV NT, PS_INV_RECV_LN NR, PS_BI_LINE NL, PS_BI_HDR NH
WHERE NT.RECEIVER_ID = NR.RECEIVER_ID
AND NT.RECV_LN_NBR = NR.RECV_LN_NBR
--AND NR.INV_RECVLN_STATUS IN ('C','O')
AND NR.SOURCE_BUS_UNIT = NL.BUSINESS_UNIT_RMA
AND NR.RMA_ID = NL.RMA_ID
AND NR.RMA_LINE_NBR = NL.RMA_LINE_NBR
AND NH.BUSINESS_UNIT = NL.BUSINESS_UNIT
AND NH.INVOICE = NL.INVOICE
AND NT.BUSINESS_UNIT = 'INPOF'
AND NT.INV_ITEM_ID = 'C825343'