Results for “vat_reg_no”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

JA.JAI_CMN_VENDOR_SITES is a table in the Oracle E-Business Suite Asia/Pacific Localizations (JA) product. It stores excise account and indirect-tax-related information about vendors and their sites, and is the principal configuration store for tax defaults applied to supplier transactions in the JA localization. Applications such as Payables, Purchasing, and the JA excise and withholding-tax modules read this table when determining how a vendor site should be taxed on a transaction.

The table is defined with a composite primary key, JAI_CMN_VENDOR_SITES_PK, on VENDOR_ID and VENDOR_SITE_ID, making the vendor-site combination the natural identity of each row. Its foreign keys to HZ_PARTIES and HZ_PARTY_SITES place it as a localization extension of the TCA (Trading Community Architecture) supplier model. Based on the foreign key topology — a composite key formed from two parent entities plus a set of descriptive tax attributes — the table exhibits a satellite-leaning Data Vault classification. Under that heuristic, HZ_PARTIES and HZ_PARTY_SITES act as hubs and this table supplies the dependent descriptive context per vendor site.

Key Information Stored

The table contains 44 documented columns. The most significant are summarized below.

• VENDOR_ID and VENDOR_SITE_ID — the composite primary key columns. VENDOR_ID references HZ_PARTIES and VENDOR_SITE_ID references HZ_PARTY_SITES, tying each row to a specific supplier and site.
• EXCISE_DUTY_REGION, EXCISE_DUTY_ZONE, EXCISE_DUTY_RANGE, EXCISE_DUTY_DIVISION, EXCISE_DUTY_CIRCLE — the Indian excise hierarchy attributes assigned to the vendor site, plus EXCISE_DUTY_REG_NO and EXCISE_DUTY_COMM for the registration number and commissionerate.
• ST_REG_NO and CST_REG_NO — the sales tax and central sales tax registration numbers used for local and inter-state transactions.
• TIN / TAX CATEGORY linkage — TAX_CATEGORY_LIST references JAI_INV_ITM_TAXCTG_HDRS and TAX_CATEGORY_ID references JAI_CMN_TAX_CTGS_ALL, controlling the tax category applied to the supplier site.
• PRICE_LIST_ID and VAT_PRICE_LIST_ID — both reference QP_LIST_HEADERS_B and drive pricing and VAT-related list selection.
• VAT_REG_NO, GST_REGISTRATION_NO, GST_ASSESSABLE_PRICE, SERVICE_TAX_REGNO, and SERVICE_TYPE_CODE — later-phase indirect tax registration and assessment attributes for VAT, GST, and service tax.
• VENDOR_TYPE, DOCUMENT_TYPE, APPROVED_INVOICE_FLAG, APPROVED_TDS_FLAG, and OVERRIDE_FLAG — classification and control flags governing excise invoicing, TDS approval, and manual override of tax defaults.
• INACTIVE_FLAG and OBJECT_VERSION_NUMBER — the standard EBS inactivity indicator and optimistic-locking column, accompanied by the WHO audit columns (CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, and so on).
• ATTRIBUTE1 through ATTRIBUTE10 — the DFF-enabled descriptive flexfield segment columns available for customer-specific extensions.

Common Use Cases and Queries

Typical scenarios include validating that a supplier site has the required excise and tax registrations before an invoice is approved, driving default tax category and price list selection during Payables invoice entry, and reporting the tax registration profile of the supplier base for statutory returns.

Querying tax defaults for a given supplier site:

SELECT v.VENDOR_ID, v.VENDOR_SITE_ID, v.EXCISE_DUTY_REG_NO,
       v.TAX_CATEGORY_ID, v.PRICE_LIST_ID, v.VAT_PRICE_LIST_ID
  FROM JA.JAI_CMN_VENDOR_SITES v
 WHERE v.VENDOR_ID = :vendor_id
   AND v.VENDOR_SITE_ID = :vendor_site_id;

Listing active supplier sites with excise registration details joins to TCA for the site name:

SELECT p.PARTY_NAME, s.PARTY_SITE_NAME, v.EXCISE_DUTY_REGION,
       v.EXCISE_DUTY_RANGE, v.ST_REG_NO, v.CST_REG_NO
  FROM JA.JAI_CMN_VENDOR_SITES v,
       HZ_PARTIES p,
       HZ_PARTY_SITES s
 WHERE v.VENDOR_ID = p.PARTY_ID
   AND v.VENDOR_SITE_ID = s.PARTY_SITE_ID
   AND v.INACTIVE_FLAG = 'N';

Exception reporting often targets sites missing a mandatory registration or price list, using INACTIVE_FLAG and null checks against TAX_CATEGORY_ID or PRICE_LIST_ID.

Related Objects

• HZ_PARTIES — joined on JAI_CMN_VENDOR_SITES.VENDOR_ID = HZ_PARTIES.PARTY_ID; supplies the supplier identity.
• HZ_PARTY_SITES — joined on JAI_CMN_VENDOR_SITES.VENDOR_SITE_ID = HZ_PARTY_SITES.PARTY_SITE_ID; supplies the site identity.
• JAI_INV_ITM_TAXCTG_HDRS — referenced by TAX_CATEGORY_LIST; defines tax category list headers.
• JAI_CMN_TAX_CTGS_ALL — referenced by TAX_CATEGORY_ID; defines the tax categories.
• QP_LIST_HEADERS_B — referenced twice, by PRICE_LIST_ID and VAT_PRICE_LIST_ID; supplies price list definitions.
• JAI_AP_TDS_INV_PAYMENTS — references this table through VENDOR_ID and VENDOR_SITE_ID, linking withholding-tax invoice payments to the supplier site configuration.

Together these relationships confirm the table's role as the localization satellite that extends the standard supplier and supplier-site masters with Asia/Pacific excise and tax attributes.