336: , H.ORDER_NUMBER
337: , H.PURCHASE_ORDER_NUM
338: , H.CURRENCY_CODE
339: FROM SO_LINE_DETAILS LD
340: , SO_HEADERS_ALL H
341: , SO_LINES_ALL L
342: WHERE H.HEADER_ID = L.HEADER_ID
343: AND L.LINE_ID = LD.LINE_ID
344: AND LD.LINE_ID = R.LINE_ID