Results for “dunning_letter_id”

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

Overview

The view IGI_DUN_LETTER_SET_LINES_V is an Oracle EBS dictionary object owned by the APPS schema and classified under the product IGI – Public Sector Financials International. Its documented purpose is to hold letter set information for the Letter Sets form, providing a denormalized, presentation-ready result set in which the child dunning letter set line records stored in IGI_DUN_LETTER_SET_LINES are enriched with the corresponding letter name from the Receivables dunning letters entity. In EBS releases 12.1.1 and 12.2.2 the view remains a standard, VALID database object available for querying by reporting tools, concurrent programs, and integration routines.

Because the view resolves the relationship between a dunning letter set line and its dunning letter definition, it is typically used to drive enquiry screens and printed output rather than to store transactional data. It exposes both the surrogate primary key of the parent letter set and the human-readable letter name, allowing callers to avoid writing additional joins against Oracle Receivables views. The presence of the DUNNING_LINE_NUM column makes the object directly relevant to searches such as dunning_line_num, since that attribute determines the ordering and sequencing of letters within a given set.

Underlying Base Objects

According to the documented view definition, the query joins two sources:

• IGI_DUN_LETTER_SET_LINES — exposed in the data dictionary as a synonym over the base letter set line entity. This is the transactional table that carries the letter set identifier, the line number, currency, the dunning letter reference, and the associated charge amounts.
• AR_DUNNING_LETTERS_VL — an Oracle Receivables view supplying the translated, language-specific LETTER_NAME value for each DUNNING_LETTER_ID.

The join predicate is IDLSL.DUNNING_LETTER_ID = ARDL.DUNNING_LETTER_ID. The letter set lines alias (IDLSL) is the driving table, and the dunning letters alias (ARDL) is used solely to resolve the descriptive letter name. In addition to the join columns, the view projects the ROWID of the base line row, aliased as ROW_ID, together with the standard EBS audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN).

Key Columns

• ROW_ID — the ROWID of the underlying IGI_DUN_LETTER_SET_LINES row, commonly used by Forms-based blocks for optimistic locking and row identification.
• DUNNING_LETTER_SET_ID — the identifier of the parent letter set to which the line belongs.
• DUNNING_LINE_NUM — the sequence number of the line within the letter set. This is the attribute most frequently referenced when searching for dunning_line_num, and it governs the order in which letters are applied.
• CURRENCY_CODE — the currency associated with the letter set line.
• DUNNING_LETTER_ID — the foreign key to the Receivables dunning letter definition.
• LETTER_NAME — the descriptive, translated name of the dunning letter sourced from AR_DUNNING_LETTERS_VL.
• LETTER_CHARGE_AMOUNT and INVOICE_CHARGE_AMOUNT — monetary charge values applied to the letter and the invoice respectively.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard audit columns inherited from the base line table.

Common Use Cases and Queries

The principal scenario for this view is retrieving the ordered lines of a specific letter set together with descriptive letter names, for example when building a letter-set review page or a reconciliation extract:

• Listing all lines for a given set: SELECT dunning_line_num, letter_name, currency_code FROM igi_dun_letter_set_lines_v WHERE dunning_letter_set_id = :p_set_id ORDER BY dunning_line_num;
• Locating a line by sequence: SELECT * FROM igi_dun_letter_set_lines_v WHERE dunning_line_num = :p_line_num;
• Summing charges per set: SELECT dunning_letter_set_id, SUM(letter_charge_amount) FROM igi_dun_letter_set_lines_v GROUP BY dunning_letter_set_id;
• Reporting on letters referenced by a set: SELECT dunning_letter_set_id, dunning_line_num, dunning_letter_id, letter_name FROM igi_dun_letter_set_lines_v ORDER BY dunning_letter_set_id, dunning_line_num;

As a view, the object is read-only and must not be used for DML; changes to letter set lines are made against the underlying base table or through the Letter Sets form.