OTM Transportation Order Number associated to an Order.sql

SELECT
	dha.source_order_number
  , Dha.status_code
  , dfla.fulfill_line_number
  , dfla.source_line_number
  , dfla.status_code
  , doc.Doc_id
FROM
	fusion.doo_document_references doc
  , fusion.doo_fulfill_lines_all   dfla
  , fusion.doo_headers_all         dha
WHERE
	dha.header_id               = dfla.header_id
	AND doc.fulfill_line_id     = dfla.fulfill_line_id
	AND dha.submitted_flag      = 'Y'
	AND doc.DOC_REF_TYPE        ='TRANSPORTATION_PLANNING_ORDER'
	AND doc.task_type           ='DOO_TransportationPlanning'
	AND Dha.source_order_number = '&Source_order_number'