Posts by Fayaz Shaik

Query to Extract GSTIN Number

This applies to India localization. To Extract the GSTIN number and pan number attached to the vendors. Script: SELECT distinct jprl.registration_number jprl.secondary_registration_number sec_registration_number FROM jai_party_regs jpr, jai_party_reg_lines jprl ap_supplier_sites_all apsa…

Read More

Supplier Site Update

This API is to update the supplier site level details. This would not applicable to   ap_vendor_pub_pkg.update_vendor_site_public(           p_api_version       => 1,    x_return_status     => lc_return_status,              …

Read More