Results for “igi_dos_destination_usages_v”

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

Overview

The view APPS.IGI_DOS_DESTINATION_USAGES_V is a reporting and integration object within the IGI – Public Sector Financials International product of Oracle E-Business Suite. It is documented as VALID in both the 12.1.1 and 12.2.2 releases and is defined as a straight projection over its base object, IGI_DOS_DESTINATION_USAGES. In the context for which the user searched "coa_id," this view is notable because it explicitly exposes the COA_ID column, which links each destination usage record to a Chart of Accounts identifier. This makes the view a convenient, denormalized entry point for queries that must resolve destination and segment-level posting configuration against a specific chart of accounts without joining to the underlying base table.

Functionally, the view presents the set of destination usages that control how public sector accounting destinations and their segments are displayed, defaulted, and made updatable during transaction entry. It surfaces the association between destinations, segments, and the accounting context (SOB_ID and COA_ID), together with the visibility, default type, default value, and updatability attributes that govern user interaction on data-entry forms.

Underlying Base Objects

The view is defined over a single base object, referenced in the documentation as the synonym IGI_DOS_DESTINATION_USAGES. No joins, unions, or aggregations are applied; the view selects the base columns directly and adds the ROWID pseudocolumn (aliased in the metadata column list as ROW_ID) for row identification. Because the definition is a simple SELECT, the view inherits the schema, constraints, and security of the base table and remains consistent with it at all times. The view is owned by APPS, and the underlying table is stored in the same schema, so no cross-schema or public synonym considerations apply to its internal query.

Key Columns

• ROW_ID – The ROWID pseudocolumn of the base row, usable as a unique row identifier for updates or drills.
• DESTINATION_ID – Identifies the accounting destination with which the usage is associated.
• SEGMENT_NAME and SEGMENT_NAME_DSP – The segment name and its display name, controlling how the segment is presented to the user.
• SOB_ID – The set of books identifier providing the accounting context for the usage.
• COA_ID – The Chart of Accounts identifier to which the destination usage is tied; this is the column most relevant to the user's search and is the key linking the usage to a specific chart of accounts.
• VISIBILITY – Indicates whether the segment is displayed during entry.
• DEFAULT_TYPE and DEFAULT_VALUE – The defaulting rule and the value applied when no user entry is provided.
• UPDATABLE – Indicates whether the user may modify the segment value.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN – Standard audit columns.

Common Use Cases and Queries

Typical uses include reporting the destination and segment usage configuration for a given chart of accounts, validating that defaulting and updatability rules are set correctly before a period, and driving data-entry form behavior. A representative query filtering on the searched attribute is:

SELECT destination_id, segment_name, segment_name_dsp,
       sob_id, coa_id, visibility, default_type,
       default_value, updatable
FROM   apps.igi_dos_destination_usages_v
WHERE  coa_id = :p_coa_id
ORDER  BY destination_id, segment_name;

A broader variant joins the view to set-of-books or chart-of-accounts lookup tables on SOB_ID and COA_ID to present descriptive names alongside the usage configuration. The view can also be queried by DESTINATION_ID or SOB_ID to retrieve the complete default and visibility profile for a destination.