Return Reason for Fulfillment Lines.sql

SELECT
	DHA.ORDER_NUMBER
  , DFLA.SOURCE_ORDER_NUMBER
  , DFLA.FULFILL_LINE_ID
  , MSC.LOOKUP_CODE
  , MSC.LOOKUP_TYPE
  , MSC.MEANING
  , MSC.language
  , MSC.refresh_number
FROM
	fusion.MSC_SR_LOOKUP_VALUES_TL MSC
  , fusion.DOO_FULFILL_LINES_ALL   DFLA
  , FUSION.DOO_HEADERS_ALL         DHA
WHERE
	DHA.HEADER_ID               = DFLA.HEADER_ID
	AND MSc.LOOKUP_TYPE         = 'RETURN_REASON'
	AND MSC.LOOKUP_CODE         = DFLA.RETURN_REASON_CODE
	AND DHA.SUBMITTED_FLAG      = 'Y'
	AND MSC.LANGUAGE            = USERENV('LANG')
	AND DHA.SOURCE_ORDER_NUMBER = '&SOURCE_ORDER_NUMBER'
;