Results for “display_flag”

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

Overview

IGS_FI_ACCT_SEGS_V is a PL/SQL view owned by the APPS schema in the Oracle E-Business Suite R12 (12.1.1 and 12.2.2) environment. It belongs to the IGS – Student System product family. The view is defined to display the account segments of the General Ledger chart of accounts that are relevant to Student System financial integration. It provides a flattened, read-only representation of accounting flexfield segment definitions, together with the associated value set information, for the chart of accounts identifier returned by the function IGS_FI_GEN_007.GET_COA_ID.

The name IGS_FI_GEN_007 referenced in the view text is a database function that returns the ID_FLEX_NUM (chart of accounts structure identifier) applicable to the Student System installation. By calling this function at query time, the view dynamically resolves against the currently configured GL chart of accounts rather than a hard-coded structure, which allows the same view to function across different implementations without modification.

Underlying Base Objects

The view is constructed as a UNION ALL over three Application Object Library reference tables. Documented base objects are:

• FND_ID_FLEX_SEGMENTS — the definition of the accounting key flexfield segments, aliased twice (FIFS and FIFSD) to support the self-join used for dependent value sets.
• FND_FLEX_VALUE_SETS — the value set definitions, aliased twice (FFVS and FFVSD) to compare parent and child value sets.
• FND_APPLICATION — used to constrain the query to the application with short name 'SQLGL' (the general ledger application), ensuring only the GL chart of accounts is returned.

Both branches of the UNION ALL join on ID_FLEX_CODE = 'GL#' and restrict to enabled segments (ENABLED_FLAG = 'Y'). The first branch selects segments whose value set has VALIDATION_TYPE = 'D' (dependent value sets) and joins parent and independent child value set ids; the second branch selects segments whose value set does not use dependent validation and returns a NULL independent segment number. This union produces one row per enabled GL segment, with independent child segments appearing additionally where dependent validation applies.

Key Columns

• SEGMENT — sourced from APPLICATION_COLUMN_NAME; identifies the underlying column in the GL account structure that corresponds to the segment.
• SEGMENT_NAME — the descriptive name of the accounting segment (for example, Company, Cost Center, Account).
• SEGMENT_NUM — the ordinal position of the segment within the accounting flexfield structure.
• FLEX_VALUE_SET_ID — the identifier of the value set attached to the segment, used to resolve valid segment values.
• VALIDATION_TYPE — the validation type of the value set (for example, 'D' for dependent, 'I' for independent).
• DISPLAY_FLAG — indicates whether the segment is displayed in the flexfield window.
• INDEPENDENT_SEGMENT_NUM — for dependent value sets, identifies the independent segment on which the dependent segment relies; NULL for independent validation types.

Common Use Cases and Queries

The view is typically used by Student System financial setups and reports that must resolve which GL segments are available for account derivation. A common example lists all enabled segments for the configured chart of accounts:

SELECT segment, segment_name, segment_num, flex_value_set_id, validation_type, display_flag
FROM   apps.igs_fi_acct_segs_v
ORDER BY segment_num;

To identify only dependent segments and their independent parents:

SELECT segment_name, segment_num, independent_segment_num
FROM   apps.igs_fi_acct_segs_v
WHERE  validation_type = 'D';

Because IGS_FI_ACCT_SEGS_V maps segment metadata rather than balances, it is commonly joined to IGS_FI_ACCT_VALID_V or similar Student System account validation views to build concatenated account strings and to drive validation logic during fee assessment, billing, and receivable account generation.