Project Information on Fulfillment Lines.sql

SELECT
	DHA.source_order_number
  , Dha.status_code
  , dla.LINE_NUMBER
  , dla.SOURCE_LINE_NUMBER
  , dla.DISPLAY_LINE_NUMBER
  , dfla.fulfill_line_number
  , dfla.Status_code
  , dpv.*
  , ppav.*
FROM
	fusion.doo_headers_all       dha
  , fusion.doo_fulfill_lines_all dfla
  , fusion.doo_lines_all         dla
  , fusion.DOO_PROJECTS_V        dpv
  , fusion.PJF_PROJECTS_ALL_VL   ppav
WHERE
	dha.header_id               = dfla.header_id
	AND dfla.line_id            = dla.line_id
	AND dfla.fulfill_line_id    = PARENT_ENTITY_ID
	AND dpv.PARENT_ENTITY_CODE  = 'LINE'
	AND dpv.PJC_PROJECT_ID      = ppav.PROJECT_ID
	and DHA.submitted_flag      = 'Y'
	and DHA.source_order_number = '&Source_Order_number'
ORDER BY
	dha.creation_Date DESC
;