SQL Query to Fulfillment Line Tax Details.sql

SELECT
	dfl.source_order_number
  , dfl.fulfill_line_id
  , zr.tax
  , zr.tax_rate_code
  , zr.tax_regime_code
  , zr.percentage_rate
FROM
	fusion.doo_headers_all             dha
  , fusion.doo_fulfill_lines_all       dfl
  , fusion.doo_order_charges           doo
  , fusion.doo_order_charge_components docc
  , fusion.doo_order_tax_details       dotd
  , fusion.zx_rates_b                  zr
WHERE
	dfl.header_id                      = dha.header_id
	AND dfl.fulfill_line_id            = doo.parent_entity_id
	AND dha.submitted_Flag             = 'Y'
	AND doo.order_charge_id            = docc.order_charge_id
	AND docc.order_charge_component_id = dotd.order_charge_component_id
	AND dotd.tax_rate_id               = zr.tax_rate_id
	AND dfl.source_order_number        = '8815'
ORDER BY
	dfl.fulfill_line_id
  , zr.tax