Search Results je_be_vat_rep_rules_v




Overview
Explore in AI Chat

Overview

The JE_BE_VAT_REP_RULES_V view is a reporting and lookup-resolution layer within the Oracle E-Business Suite European Localizations (JE) product, specifically supporting Belgian VAT reporting. It presents the contents of the configuration table JE_BE_VAT_REP_RULES in a fully decoded, human-readable form, joining each stored lookup code against the FND_LOOKUPS dictionary so that internal codes are replaced by their meanings and descriptions. The view resides in the APPS schema and carries a VALID status in both 12.1.1 and 12.2.2. Its principal function is to drive the rules that determine how a given transaction — sourced from Payables, Receivables, General Ledger, or Cash Management — is classified for Belgian VAT reporting purposes, including the applicable VAT transaction type, report box assignment, sign flag, and line type. Because the view exposes both raw codes and their display equivalents, it serves as a convenient foundation for concurrent programs, BI Publisher reports, and diagnostic queries that need to inspect or validate VAT reporting setup without performing manual lookup joins.

Underlying Base Objects

According to the documented ETRM metadata, the view references three principal base objects: the FND_LOOKUPS view, the FND_GLOBAL package, and the JE_BE_VAT_REP_RULES synonym (which points to the underlying configuration table). The FND_LOOKUPS view is instantiated seven times within the defining SQL, each aliased to resolve a distinct lookup type: JEBE_SOURCE, JEBE_VAT_TRANS_TYPE, JEBE_LINE_TYPE, JEBE_VAT_REPORT_BOXES, JEBE_SIGN_FLAG, and the YES_NO lookup that resolves the ENABLED_FLAG. The order-of-transaction lookup type is resolved dynamically via a DECODE expression that selects JEBE_AP_OF_TRANS_TYPE, JEBE_AR_OF_TRANS_TYPE, JEBE_GL_OF_TRANS_TYPE, or JEBE_CR_OF_TRANS_TYPE depending on the SOURCE column. The JE_BE_VAT_REP_RULES table supplies the driving rows, joined to each lookup alias on the corresponding code column. FND_GLOBAL provides the standard EBS session context used for security and auditing within the localization layer.

Key Columns

The view exposes a comprehensive set of columns. SET_OF_BOOKS_ID identifies the ledger context for each rule. SOURCE and SOURCE_DSP hold the raw and displayed source application code (AP, AR, GL, CR). OF_TRANS_TYPE and OF_TRANS_TYPE_DSP give the order or transaction type code and meaning, drawn from the source-specific lookup type. The columns most relevant to the searched term, vat_trans_type, include VAT_TRANS_TYPE (the raw lookup code), VAT_TRANS_TYPE_DSP (its meaning), and VAT_TRANS_TYPE_DESC (its description from JEBE_VAT_TRANS_TYPE). TAX_NAME carries the associated tax name. LINE_TYPE and LINE_TYPE_DSP describe the reporting line classification, while VAT_REPORT_BOX and NOREC_VAT_REP_BOX (with their _DSP counterparts) designate the primary and non-recoverable VAT report box assignments. SIGN_FLAG, ENABLED_FLAG, START_DATE_ACTIVE, END_DATE_ACTIVE, and the standard audit columns (creation and update metadata) complete the structure. ROW_ID exposes the physical row identifier for the base table.

Common Use Cases and Queries

Typical uses include verifying VAT transaction type configuration, auditing report box assignments, and feeding downstream Belgian VAT reports. A representative query filtering on the searched term is:

  • SELECT vat_trans_type, vat_trans_type_dsp, source, of_trans_type, tax_name, vat_report_box, enabled_flag FROM apps.je_be_vat_rep_rules_v WHERE vat_trans_type = :p_code AND set_of_books_id = :p_sob AND enabled_flag = 'Y';
  • Listing all active rules for a ledger: SELECT * FROM apps.je_be_vat_rep_rules_v WHERE set_of_books_id = :p_sob AND end_date_active IS NULL;
  • Auditing days-based validity: SELECT vat_trans_type_dsp, start_date_active, end_date_active FROM apps.je_be_vat_rep_rules_v WHERE start_date_active > SYSDATE - 30;

Because the view resolves all lookups, it is well suited to ad hoc validation of Belgian VAT setup before period-end reporting.