Search Results charge_center_name

Overview

IGI_ITR_CHARGE_ORIG_SS_V is an Oracle E-Business Suite (EBS) applications view owned by the APPS schema. It belongs to the Oracle Public Sector/Government incentive and grant management product family, specifically the IGI (Intellectual/IGI) module used for interagency transaction and charge processing. The suffix "SS_V" indicates it is a secure, single-source style view intended for form and report data retrieval within the IGI Interagency Transaction (ITR) functionality.

The view presents originator-level charge records combined with user identity and charge center descriptive information. Rather than requiring application code or custom reports to perform multi-table joins against origination, charge center, and user tables, the view delivers a denormalized, ready-to-query result set. This makes it a convenient integration and reporting surface for developers who need originator names, flexfield segments, and charge center context in a single SELECT.

Underlying Base Objects

The view definition is grounded in three documented base objects, all exposed as synonyms in the APPS schema:

• IGI_ITR_CHARGE_ORIG — aliased as ORIG, this is the primary driving table. It supplies the originator record, flexfield segment columns (SEGMENT1 through SEGMENT30), the charge origination identifier, and standard WHO columns.
• IGI_ITR_CHARGE_CENTER — aliased as CC, joined on CHARGE_CENTER_ID. It contributes SET_OF_BOOKS_ID and the descriptive CHARGE_CENTER_NAME.
• FND_USER — aliased as FND, joined on ORIG.ORIGINATOR_ID = FND.USER_ID. It provides the USER_NAME value that is exposed as PERSON_NAME_DSP.

The join is an inner join across all three objects, meaning a row is only returned when a matching charge center and a matching FND user both exist for the origination row.

Key Columns

The view exposes a broad set of columns. The most significant include:

• ROW_ID — the ROWID of the underlying origination row, useful for direct updates or row identification.
• CHARGE_ORIG_ID, CHARGE_CENTER_ID, ORIGINATOR_ID — primary and foreign key identifiers linking the origination record to its charge center and originating user.
• PERSON_NAME_DSP — the display name of the originator, sourced from FND_USER.USER_NAME. This is the column most directly associated with the user search term "person_name_dsp".
• EMPLOYEE_ID — the employee associated with the originator, where applicable.
• CONCATENATED_SEGMENTS, ID_FLEX_CODE, ID_FLEX_NUM — key flexfield context and the concatenated account string.
• SEGMENT1 through SEGMENT30 — the individual key flexfield segment values. Note that the source listing contains an inconsistent alias for SEGMENT7 (aliased as SEGMENT rather than SEGMENT7), a detail worth verifying at runtime.
• START_DATE, END_DATE — the effective date range of the origination assignment.
• CHARGE_CENTER_NAME, SET_OF_BOOKS_ID — descriptive and ledger context from the charge center.
• WHO columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN) — audit tracking.

Common Use Cases and Queries

Typical scenarios include displaying originator names on IGI charge forms, generating reports of charges by originating user, and joining origination data to accounting ledgers via SET_OF_BOOKS_ID. A representative query filtering by the searched column follows:

• Look up charges by originator display name: SELECT charge_orig_id, person_name_dsp, charge_center_name FROM apps.igi_itr_charge_orig_ss_v WHERE person_name_dsp = :p_name;
• List active originations within a date window: SELECT person_name_dsp, start_date, end_date FROM apps.igi_itr_charge_orig_ss_v WHERE SYSDATE BETWEEN start_date AND NVL(end_date, SYSDATE);
• Report charges grouped by charge center: SELECT charge_center_name, COUNT(*) FROM apps.igi_itr_charge_orig_ss_v GROUP BY charge_center_name;

Because the view resolves the FND_USER and charge center joins internally, these queries avoid redundant join logic and remain consistent across the IGI module.