Creation and Last Updated by (WHO) information on Order Headers, Order Lines and Fulfillment Lines.sql

SELECT
	dha.header_id
  , dha.Source_order_number
  , dha.ORDER_NUMBER
  , dha.source_order_id
  , dha.status_code
  , dha.submitted_flag
  , dha.open_flag
  , dha.canceled_flag
  , dha.CREATION_DATE
  , dha.CREATED_BY
  , dha.OBJECT_VERSION_NUMBER
  , dha.LAST_UPDATE_DATE
  , dha.LAST_UPDATED_BY
  , 'Order Line' " "
  , dla.Line_id
  , dla.DISPLAY_LINE_NUMBER
  , dla.source_line_number
  , dla.line_number
  , dla.status_code
  , dla.open_flag
  , dla.canceled_flag
  , dla.CREATION_DATE
  , dla.CREATED_BY
  , dla.OBJECT_VERSION_NUMBER
  , dla.LAST_UPDATE_DATE
  , dla.LAST_UPDATED_BY
  , 'Fulfillment Line' " "
  , dfla.FULFILL_LINE_NUMBER
  , dfla.MODIFIED_FLAG
  , dfla.source_line_number
  , dfla.status_code
  , dfla.open_flag
  , dfla.canceled_flag
  , dfla.CREATION_DATE
  , dfla.CREATED_BY
  , dfla.OBJECT_VERSION_NUMBER
  , dfla.LAST_UPDATE_DATE
  , dfla.LAST_UPDATED_BY
FROM
	fusion.doo_headers_all       dha
  , fusion.doo_fulfill_lines_all dfla
  , fusion.doo_lines_all         dla
WHERE
	dha.source_order_number = '&Source_order_number'
	--        Remove Comments to search for ONLY submitted orders
	AND dha.submitted_flag = 'Y'
	AND dha.header_id      = dfla.header_id
	AND dfla.line_id       = dla.line_id
ORDER BY
	dha.creation_Date DESC