sql

SELECT 
NH.USER1
 
	Let $Documento = 'CRE#' || Rtrim(&NH.USER1, ' ')
 
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 = &A.BUSINESS_UNIT
AND NT.INV_ITEM_ID = &A.INV_ITEM_ID
AND NT.DT_TIMESTAMP = &A.DT_TIMESTAMP
AND NT.SEQ_NBR = &A.SEQ_NBR