Script to Find Lower Threshold Tax slab Vendors Registered Details

This Query is useful to fetch the vendor details that are having certificates for lower Tax Deduction rates or Exceptional Tax Deduction case vendors.

Script:

SELECT
vendor_name,
pan_no,
org_tan_num,
vendor_type_code,
vendor_id,
section_type,
section_code,
certificate_number,
start_date,
end_date,
threshold_exception_id
FROM
jai_ap_wthld_thhold_excp_v;