Script to find GST Taxes against Inventory Receipt (GRN)

--Query to find the GST Taxes against Inventory Receipt (GRN)

SELECT jtl.tax_invoice_num, jtl.tax_invoice_date, jtl.org_id,
       jtl.organization_id, jtl.creation_date, jtl.item_id,
       jtl.event_type_code, jtl.tax_event_class_code, jtl.ledger_id,
       jtl.trx_number, jtl.trx_line_number, jtl.line_amt,
       jtl.trx_line_quantity, jtl.trx_currency_code,
       jtl.currency_conversion_rate, jtl.currency_conversion_date,
       jtl.functional_currency_code, jtl.tax_regime_id, jtl.tax_regime_code,
       jtl.first_party_primary_reg_name, jtl.first_party_primary_reg_num,
       jtl.first_party_secondary_reg_name, jtl.first_party_secondary_reg_num,
       jtl.tax_point_basis, jtl.tax_rate_code, jtl.tax_rate_type,
       jtl.tax_rate_percentage, jtl.tax_rounding_factor,
       jtl.unround_tax_amt_fun_curr, jtl.unround_tax_amt_trx_curr,
       jtl.rounded_tax_amt_fun_curr, jtl.rounded_tax_amt_trx_curr,
       jtl.rounded_taxable_amt_fun_curr, jtl.rounded_taxable_amt_trx_curr
  FROM jai_tax_lines jtl,
       rcv_shipment_headers rsh,
       rcv_shipment_lines rsl,
       rcv_transactions rt,
       jai_regimes jr,
       jai_tax_types jtt
 WHERE 1 = 1
   AND jtl.trx_id = rsh.shipment_header_id
   AND rt.shipment_header_id = rsh.shipment_header_id
   AND jtl.trx_id = :p_shipment_header_id
   AND jtl.event_type_code = 'RECEIPT_CREATED'
   AND jtl.trx_type = 'RECEIVE'
   AND jtl.trx_line_id = rsl.shipment_line_id
   AND rt.shipment_line_id = rsl.shipment_line_id
   AND jtl.org_id = :p_org_id
   AND jtl.trx_type = rt.transaction_type
   AND jtl.tax_regime_id = jr.regime_id
   AND jtl.tax_type_id = jtt.tax_type_id;