To Identify Backlog Planning Release Status on Fulfillment Lines.sql

SELECT
	dha.source_order_number
  , dha.order_number
  , dha.source_order_id
  , dla.SOURCE_LINE_NUMBER
  , dla.DISPLAY_LINE_NUMBER
  , dfla.fulfill_line_number
  , dfla.status_code
  , dfla.SCHEDULING_REASON_CODE
FROM
	fusion.doo_headers_all       dha
  , fusion.doo_fulfill_lines_all dfla
  , fusion.doo_lines_all         dla
WHERE
	dha.header_id               = dfla.header_id
	AND dfla.line_id            = dla.line_id
	AND dha.submitted_flag      = 'Y'
	AND dha.source_order_number = '&SOURCE_ORDER_NUMBER'