Results for “tax_type”

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

Overview

JAI_FBT_TAX_TYPE_V is a database view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the JA (Asia/Pacific Localizations) product family. It is a static, inline-defined view whose sole purpose is to enumerate the tax types that comprise Fringe Benefit Tax (FBT) processing as implemented for the relevant Asia/Pacific localization. According to the ETRM documentation, the view "stores the FBT tax type information listing current 4 kinds of FBT taxes." In practice, it functions as a lightweight lookup or reference view rather than a transactional data source; it returns a fixed, hard-coded result set of four distinct tax type values that downstream FBT-related logic, reports, and integrations can consume consistently.

Because the view contains no date-effective or organization-specific columns, its role is to provide a normalized, queryable enumeration of FBT tax categories instead of requiring consumers to hard-code the same literals. This is typical of localization reference views in EBS, where a fixed value list is exposed through a view to decouple report or interface logic from embedded constants.

Underlying Base Objects

The view is not defined over any application transaction table. Its view text is composed entirely of a series of SELECT ... FROM DUAL statements combined with UNION ALL, wrapped in an outer inline view. The only referenced base object documented in the ETRM metadata is the DUAL synonym, which is a standard Oracle single-row pseudo-table used to generate scalar and literal result sets.

Consequently, JAI_FBT_TAX_TYPE_V has no dependency on FBT transactional tables, tax setup tables, or localization configuration tables. There are no joins, no WHERE clauses binding it to business data, and no parameters. The view is deterministic and returns the same four rows for every query, regardless of operating unit, ledger, or session context.

Key Columns

The view exposes a single column, documented as TAX_TYPE. Its values are derived from string literals in the inline view definition. The four documented FBT tax types are:

• FBT — the base Fringe Benefit Tax category.
• SURCHARGE — the surcharge component applied on top of the base FBT.
• EDU. CESS — the education cess component, presented with an embedded period and space as a literal value.
• SHE. CESS — the secondary and higher education cess component, similarly presented as a literal.

Because the column values are string literals, consumers must match them exactly, including punctuation and spacing (for example, 'EDU. CESS' rather than 'EDU CESS'). The column carries no additional attributes such as descriptions, effective dates, enabled flags, or tax rate identifiers; it is purely a type enumerator.

Common Use Cases and Queries

The principal use case is populating list-of-values style selections, validation routines, or report parameters that must restrict input to the valid FBT tax types. It is also useful in integration or conversion scripts that need to iterate over all FBT tax categories without hard-coding literals, and in reconciliation or audit reports that summarize amounts by tax type.

A basic query retrieves the full enumeration:

• SELECT tax_type FROM apps.jai_fbt_tax_type_v ORDER BY tax_type;

To drive a lookup or validation, the values can be joined to FBT transaction or tax detail data by matching the tax type attribute, for example aggregating amounts by type where the stored type value equals the view's TAX_TYPE. In list-of-values definitions, the view is frequently queried simply as a value source:

• SELECT tax_type FROM apps.jai_fbt_tax_type_v;

Because the view is static, it is inexpensive to query and safe to reference in reports, concurrent program parameters, and BI Publisher data templates within the JA localization context. It should not be treated as a configuration table: changes to the FBT tax type set are delivered through patching of the view definition, not through data maintenance.