Search Results tx_tloc_asc




Overview
Explore in AI Chat

Overview

The TX_TLOC_ASC table is a core data object within the Oracle E-Business Suite (EBS) Process Manufacturing Logistics (GML) module. It functions as an association table, defining the specific tax authorities that are applicable for a given pair of tax locations. Its primary role is to establish and maintain the relationships between tax jurisdictions and the governing authorities that levy taxes on transactions between those locations. This mapping is critical for accurate and compliant tax determination and calculation within the manufacturing and logistics processes of EBS, particularly in scenarios involving cross-location transfers or shipments.

Key Information Stored

The table's structure centers on two primary foreign key columns that form its composite primary key, TX_TLOC_ASC_PK. The TAXLOC_ID column identifies a specific tax location, while the TAXAUTH_ID column identifies a specific tax authority. The association record signifies that the designated authority has jurisdiction over transactions involving the specified location pair. An additional column, TEXT_CODE, is linked to the TX_TEXT_HDR table, which is a standard EBS construct for storing descriptive, translatable text. This likely allows for storing notes or descriptive information about the specific tax authority-location association.

Common Use Cases and Queries

This table is primarily accessed during the tax engine's determination phase. When a logistics transaction (such as an inter-organization transfer) is initiated between two points, the system queries TX_TLOC_ASC to identify all relevant tax authorities for the involved location pair. Common reporting and validation queries include listing all authorities for a specific location or verifying the setup for a critical shipping lane. A typical SQL pattern would be a join to the tax authority (TX_TAXA_MST) and tax location master tables to produce a readable report:

  • SELECT tla.taxloc_id, tam.taxauth_code, tam.name
    FROM gml.tx_tloc_asc tla,
    gml.tx_taxa_mst tam
    WHERE tla.taxauth_id = tam.taxauth_id
    AND tla.taxloc_id = :p_tax_location_id;

Related Objects

As indicated by its foreign keys, TX_TLOC_ASC has direct dependencies on several key tax-related master tables and is part of a larger data model. The table TX_TAXA_MST provides the master list of tax authorities referenced by TAXAUTH_ID. The table TX_TOFR_ASC is referenced via the TAXLOC_ID, suggesting it is a parent table for tax location definitions or associations. The link to TX_TEXT_HDR via TEXT_CODE provides descriptive flexibility. Consequently, this table sits at a junction point, connecting location data, authority data, and descriptive text within the GML tax subsystem.