Results for “clause_ref”

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

Overview

JE_IT_EXEMPT_LETTERS_V is an APPS-owned database view in the Oracle E-Business Suite European Localizations (JE) product family, introduced to support the Italian Exemption Letter functionality. Its stated purpose is to display the exemption letter type and the Italian legislation clause on the Italian Exemption Letter form. Rather than being a standalone data source, the view functions as a presentation and reporting layer: it joins the underlying exemption letter records to Oracle Application Object Library lookup values so that coded values (CLAUSE_REF and LETTER_TYPE) are surfaced alongside their translated, user-facing meanings (CLAUSE_REF_DSP and LETTER_TYPE_DSP). The object is documented as VALID in ETRM for release 12.2.2 and applies equally to 12.1.1, where the same Italian localization features are delivered.

The view is relevant to users searching for the ISSUE_DATE column, since that column is one of the exemptions lifecycle attributes exposed directly by this view.

Underlying Base Objects

Per the documented 12.2.2 metadata, JE_IT_EXEMPT_LETTERS_V is defined over the following objects:

• JE_IT_EXEMPT_LETTERS (SYNONYM) — the primary transactional table holding exemption letter records, aliased as EL. All core business attributes (legal entity, vendor, effective dates, year, exemption letter identifier, clause reference, print/custom/issue flags, issue date, set of books, letter type, and limit amount) originate from this table.
• FND_LOOKUPS (VIEW) — referenced twice as LU1 and LU2. LU1 resolves the clause reference where LOOKUP_TYPE = 'JEIT_CLAUSE_REF'; LU2 resolves the letter type where LOOKUP_TYPE = 'JEIT_EXEMPT_LETTER'.
• FND_GLOBAL (PACKAGE) — referenced by the view, consistent with standard EBS multi-org and session context resolution.

Because the joins to FND_LOOKUPS are inner joins on LOOKUP_CODE equality, a row is returned only when both the clause reference and letter type carry valid lookup codes of the appropriate lookup types.

Key Columns

• ROW_ID — the ROWID of the base exemption letter row, used for row-level identification.
• LEGAL_ENTITY_ID, VENDOR_ID, SET_OF_BOOKS_ID — organizational and third-party context for the exemption letter.
• EXEMPTION_LETTER_ID — the primary identifier of the exemption letter record.
• EFFECTIVE_FROM, EFFECTIVE_TO, YEAR — the validity window and fiscal year of the letter.
• CLAUSE_REF and CLAUSE_REF_DSP — the stored Italian legislation clause code and its lookup meaning.
• LETTER_TYPE and LETTER_TYPE_DSP — the stored exemption letter type code and its lookup meaning.
• ISSUE_FLAG and ISSUE_DATE — whether the letter has been issued and the date it was issued, the value frequently searched for under the term "issue_date".
• PRINT_FLAG, CUSTOM_FLAG, LIMIT_AMOUNT — printing status, customization indicator, and any monetary ceiling associated with the letter.
• Audit columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN.

Common Use Cases and Queries

Typical scenarios include reporting on issued Italian exemption letters, reconciling vendor exemption coverage by legal entity, and verifying that clause references and letter types resolve to valid lookup meanings. A representative query filtering on the issue date follows:

• SELECT exemption_letter_id, legal_entity_id, vendor_id, letter_type_dsp, clause_ref_dsp, issue_date, effective_from, effective_to FROM apps.je_it_exempt_letters_v WHERE issue_date BETWEEN :p_from AND :p_to ORDER BY issue_date;
• SELECT legal_entity_id, vendor_id, COUNT(*) FROM apps.je_it_exempt_letters_v WHERE issue_flag = 'Y' GROUP BY legal_entity_id, vendor_id;
• SELECT exemption_letter_id, issuer, letter_type_dsp, clause_ref_dsp, limit_amount FROM apps.je_it_exempt_letters_v WHERE clause_ref = 'CLAUSE_CODE';

Queries should be executed against the APPS schema or through a synonym, with appropriate FND_GLOBAL session context, given the localization and multi-org nature of the underlying data.