Search Results jai_cmn_vendor_sites

Overview

The JAI_CMN_VENDOR_SITES table is a core data object within the Asia/Pacific Localizations (JA) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It functions as an extension to the standard supplier (vendor) site model, specifically designed to store excise account and other tax-related information pertinent to vendors. Its primary role is to support complex indirect tax compliance requirements, such as excise and value-added tax (VAT), mandated in various Asia/Pacific jurisdictions. The table is integral to ensuring that tax calculations, reporting, and vendor payments adhere to localized legal frameworks by maintaining vendor-site-level tax attributes not found in the standard EBS supplier tables.

Key Information Stored

While the specific column list is not detailed in the provided metadata, the table's description and foreign key relationships clearly define the nature of its data. The table is anchored by a composite primary key on VENDOR_ID and VENDOR_SITE_ID, linking it directly to the Trading Community Architecture (TCA) party (HZ_PARTIES) and party site (HZ_PARTY_SITES) records. Key supplemental information stored includes references to tax categories (TAX_CATEGORY_ID, TAX_CATEGORY_LIST), which govern applicable excise duties, and price lists (PRICE_LIST_ID, VAT_PRICE_LIST_ID) used for tax-inclusive or tax-exclusive pricing scenarios. This structure allows for precise tax rule assignment at the granular level of a specific vendor operating location.

Common Use Cases and Queries

This table is primarily accessed during the procure-to-pay lifecycle for tax determination and statutory reporting. Common operational scenarios include the automatic derivation of excise duty during invoice validation, the application of Tax Deducted at Source (TDS) rules as indicated by its relationship with JAI_AP_TDS_INV_PAYMENTS, and the generation of localized tax registers. A typical query would join this table to supplier and TCA tables to retrieve a vendor site's complete tax profile.

• Sample Query: Retrieving excise tax details for a vendor site.
  SELECT jcvs.*, hp.party_name, hps.party_site_name
FROM jai_cmn_vendor_sites jcvs,
    hz_parties hp,
    hz_party_sites hps
WHERE jcvs.vendor_id = hp.party_id
  AND jcvs.vendor_site_id = hps.party_site_id
  AND hp.party_number = 'VENDOR123';

Related Objects

JAI_CMN_VENDOR_SITES is a central hub within the JA localization's data model, with documented relationships to several key objects. It references master data tables for tax rules and pricing, and is itself referenced by transactional tables.

• Primary Key Reference: JAI_CMN_VENDOR_SITES_PK (VENDOR_ID, VENDOR_SITE_ID).
• Foreign Keys (References To):
  • HZ_PARTIES on JAI_CMN_VENDOR_SITES.VENDOR_ID
  • HZ_PARTY_SITES on JAI_CMN_VENDOR_SITES.VENDOR_SITE_ID
  • JAI_INV_ITM_TAXCTG_HDRS on JAI_CMN_VENDOR_SITES.TAX_CATEGORY_LIST
  • QP_LIST_HEADERS_B on JAI_CMN_VENDOR_SITES.PRICE_LIST_ID
  • QP_LIST_HEADERS_B on JAI_CMN_VENDOR_SITES.VAT_PRICE_LIST_ID
  • JAI_CMN_TAX_CTGS_ALL on JAI_CMN_VENDOR_SITES.TAX_CATEGORY_ID
• Referenced By (Child Table):
  • JAI_AP_TDS_INV_PAYMENTS references JAI_CMN_VENDOR_SITES on (VENDOR_ID, VENDOR_SITE_ID).