Verify that Header Attribute Values Have Been Overridden on Order Fulfillment Lines.sql

SELECT
	dha.source_order_number
  , dha.header_id
  , dfla.fulfill_line_id
  , dfla.PREF_OVERRIDDEN_BITSET
FROM
	fusion.doo_headers_all       dha
  , fusion.doo_fulfill_lines_all dfla
WHERE
	dha.header_id               = dfla.header_id
	AND dha.submitted_flag      = 'Y'
	AND dha.source_order_number = ‘&Source_order_number’
	--        AND PREF_OVERRIDDEN_BITSET IS NOT NULL
ORDER BY
	dha.creation_Date DESC