Results for “jai_fbt_setup_header_v”

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

Overview

JAI_FBT_SETUP_HEADER_V is a database view owned by the APPS schema within the JA — Asia/Pacific Localizations product family. It exposes header-level Fringe Benefit Tax (FBT) setup information, and its documented purpose is to populate the header block of the Fringe Benefit Tax Setup form. Because the view consolidates setup data with descriptive lookup meanings, it is equally useful for reporting and integration: it presents a denormalized, human-readable projection of FBT configuration for a given legal entity, including the statutory rates applied and the account used for FBT accounting. The view is documented as VALID in EBS 12.2.2 and is present in 12.1.1 as well.

Underlying Base Objects

The view is defined over three referenced objects:

• JAI_FBT_SETUP (referenced as a SYNONYM) — the primary setup table holding the FBT configuration rows per legal entity, including assessment status, business type, rates, and the account CCID.
• JA_LOOKUPS (referenced as a VIEW) — the Asia/Pacific lookup view, joined twice under the aliases AJ and BJ to resolve the assessment status code and the business type code into their translated meanings.
• XLE_ENTITY_PROFILES (referenced as a SYNONYM) — the legal entity definition source, joined on LEGAL_ENTITY_ID.

The view text performs inner joins between JAI_FBT_SETUP and XLE_ENTITY_PROFILES on LEGAL_ENTITY_ID, and joins JA_LOOKUPS twice with the filters AJ.LOOKUP_TYPE = 'JAI_ASSESSMENT_STATUS' and BJ.LOOKUP_TYPE = 'JAI_BUSINESS_TYPE'. A DISTINCT clause eliminates duplicates. Consequently, only setup rows whose legal entity exists in XLE_ENTITY_PROFILES and whose assessment status and business type codes have valid lookup entries are returned.

Key Columns

• LEGAL_ENTITY_ID — identifier of the legal entity for which FBT parameters are configured.
• LEGAL_ENTITY — the legal entity name sourced from XLE_ENTITY_PROFILES.
• ASSESSMENT_STATUS_CODE / ASSESSMENT_STATUS — the stored assessment status code and its lookup meaning from the JAI_ASSESSMENT_STATUS lookup type.
• BUSINESS_TYPE_CODE / BUSINESS_TYPE — the stored business type code and its lookup meaning from the JAI_BUSINESS_TYPE lookup type. This is the column set relevant to searches on "business_type"; the BUSINESS_TYPE column supplies the translated description, while BUSINESS_TYPE_CODE is the underlying stored value.
• FBT_RATE, SURCHARGE_RATE, EDU_CESS_RATE, SH_CESS_RATE — the statutory FBT rate, surcharge rate, education cess rate, and secondary/higher education cess rate applicable to the setup.
• FBT_ACCOUNT_CCID — the account code combination identifier used for FBT accounting postings.

Common Use Cases and Queries

The view is typically queried to review or extract FBT configuration for reporting, reconciliation, or as the source for concurrent program logic. A representative query retrieving setup by business type is:

• SELECT legal_entity, business_type, fbt_rate, surcharge_rate FROM jai_fbt_setup_header_v WHERE business_type_code = :p_business_type;
• SELECT legal_entity_id, legal_entity, assessment_status, business_type, fbt_account_ccid FROM jai_fbt_setup_header_v ORDER BY legal_entity;

Because the view resolves lookup meanings, it is preferred over querying JAI_FBT_SETUP directly for user-facing extracts. Note the inner joins: if a lookup row is missing or the legal entity is not defined in XLE_ENTITY_PROFILES, that setup row will not appear.