Results for “igi_itr_ch_lines_app_v”

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

Overview

IGI_ITR_CH_LINES_APP_V is a reporting view owned by the APPS schema within the IGI — Public Sector Financials International product family. It exposes individual International Transaction (ITR) charge lines alongside their parent charge header, charge center, and originating user context. The view is validated and marked VALID in both Oracle EBS 12.1.1 and 12.2.2, and it is primarily consumed by the charge line approval and posting inquiry user interfaces, as well as by custom reporting and integration extracts that must reconcile charge line status, amounts, and accounting distribution.

In the context of the user search term posting_flag, this view is the principal consolidation point where the charge line posting indicator surfaces to the application layer. Because POSTING_FLAG is carried directly from IGI_ITR_CHARGE_LINES, any analysis of posting state for charge lines should be anchored on this view.

Underlying Base Objects

The view is defined over four documented base objects, all accessed through APPS synonyms:

• IGI_ITR_CHARGE_LINES — the driving table; supplies status, amounts, accounting identifiers, posting flag, and audit columns.
• IGI_ITR_CHARGE_HEADERS — joined on IT_HEADER_ID; supplies header name, currency code, and the ITR originator identifier.
• IGI_ITR_CHARGE_CENTER — joined on CHARGE_CENTER_ID; supplies the charge center name.
• FND_USER — joined on HEADER.IT_ORIGINATOR_ID = FU.USER_ID; supplies the originator user name.

The join condition is a straight inner join chain across all four objects. This means a charge line will not appear in the view if its header, charge center, or originating FND_USER record is missing. The view text also contains a commented-out DECODE expression that would have resolved POSTING_FLAG to an FND_LOOKUPS meaning — this lookup-based display column is disabled in the documented definition.

Key Columns

• POSTING_FLAG — the charge line posting indicator, passed unchanged from IGI_ITR_CHARGE_LINES. This is the column of interest for posting-state reporting.
• ROW_ID — the ROWID of the charge line, used for row-level identification in Forms-based inquiry screens.
• STATUS_FLAG — the workflow/approval status of the charge line.
• IT_LINE_NUM / IT_HEADER_ID — the line number and parent header key, enabling grouping by ITR document.
• ENTERED_DR / ENTERED_CR / SUGGESTED_AMOUNT — the debit, credit, and system-suggested amounts for the line.
• CHARGE_CENTER / CHARGE_CENTER_ID — the descriptive and key identifiers for the owning charge center.
• CODE_COMBINATION_ID / SET_OF_BOOKS_ID — accounting flexfield and ledger context for the distribution.
• ORIGINATOR_NAME / HEADER_NAME / CURRENCY_CODE — denormalized descriptive attributes pulled from FND_USER and the charge header.
• SUBMIT_DATE, EFFECTIVE_DATE, CREATION_DATE, LAST_UPDATE_DATE and the standard WHO audit columns — for aging, audit, and reconciliation reporting.

Common Use Cases and Queries

The most frequent scenario is identifying charge lines by posting state, typically to find unposted or successfully posted lines for a given ITR or period. A representative query:

• SELECT it_line_num, header_name, charge_center, posting_flag, entered_dr, entered_cr, suggested_amount FROM igi_itr_ch_lines_app_v WHERE posting_flag IS NOT NULL AND effective_date BETWEEN :start_date AND :end_date;
• SELECT posting_flag, COUNT(*) FROM igi_itr_ch_lines_app_v GROUP BY posting_flag; — for reconciliation of posting volumes.
• SELECT h.header_name, l.it_line_num, l.posting_flag, l.status_flag FROM igi_itr_ch_lines_app_v l WHERE originator_name = :user AND currency_code = :currency; — support and audit drill-down by originator.

Because POSTING_FLAG is exposed literally rather than through the disabled lookup DECODE, consumers requiring a meaningful description must join to FND_LOOKUPS themselves, typically on the posting_flag lookup type used by the IGI ITR charge line module.