Third Party Registration script

Hi All,

To get Suppliers Third party registration details for TDS regime, we can use the below script to get the data.

select aps.vendor_name,

    aps.segment1,

    jpl.registration_type_code,

    jpl.registration_number,

    jpl.sec_registration_type_code,

    jpl.secondary_registration_number,

    jpl.default_section_code,

    jpl.effective_from,

    jpl.effective_to

 from jai_party_regs jpr, 

 jai_party_reg_lines jpl, 

 ap_suppliers aps

 where 1 = 1

  and jpl.party_reg_id = jpr.party_reg_id

  and aps.vendor_id = jpr.party_id

  and jpl.regime_id = 10002;

Thanks

Mohan