GST Tables- Oracle apps R12
# Getting Vendors/Customers GSTIN number Sql 1: For supplier: select party_reg_id from Jai_Party_Regs where supplier_flag = 'Y' ; party id is vendor id in ap_suppliers party_site_id is vendor_site_id in ap_supplier_sites_all For Customer select party_reg_id from Jai_Party_Regs where customer_flag = 'Y' ; party id is cust_account_id in hz_cust_accounts party_site_id is cust_acct_site_id in hz_cust_acct_sites_all sql 2: select REGISTRATION_NUMBER from jai_party_reg_lines where party_reg_id=&party_reg_id (party_Reg_id from 1st query) ---------------------------------------------------------------------- # Getting Tax Category SELECT JAIR.REGIME_ID, JAIR.REGIME_CODE, JAIR.REGIME_NAME, JAIR.TAX_AUTHORITY_ID, JAITT.TAX_TYPE_ID, ...