Search Results igi_exp_du_status




Overview
Explore in AI Chat

Overview

APPS.IGI_EXP_DUS_IN_TUS_V is a reporting and integration view in Oracle E-Business Suite that exposes Document Utilization (DU) records that have been associated with a Tracking Unit (TU). It is part of the Oracle Grants/IGI Expense (IGI_EXP) schema family, which supports expense tracking, document utilization, and tracking unit management for governmental and grant-funded operations. The view consolidates a DU header record with its descriptive, currency, status, and audit context so that downstream reports, concurrent programs, and interfaces can query fully described DU rows without performing the joins themselves.

The defining characteristic of this view is the predicate IED.TU_ID IS NOT NULL. Only DU records already linked to a Tracking Unit are returned, which distinguishes this view from the base DU entity and makes it the appropriate source for TU-oriented reporting. The user search term "igi_exp_du_status" corresponds directly to the status columns exposed here: the raw code column DU_STATUS and its decoded counterpart STATUS_DESC, resolved through the IGI_LOOKUPS view using lookup type IGI_EXP_DU_STATUS. The view carries an ORG_ID column, so it is multi-org aware and must be queried with the appropriate operating unit or through a MOAC-enabled query.

Underlying Base Objects

The view is defined over six documented objects in the APPS schema:

All joins are equi-joins on the corresponding key columns; the view is effectively a denormalized projection of the DU header plus reference data.

Key Columns

Common Use Cases and Queries

Typical uses include TU-level utilization reports, reconciliation of DU status against the IGI_EXP_DU_STATUS lookup, grant expense dashboards, and integration extracts where consumed DUs tied to tracking units are needed with decoded values.

Retrieve DUs for a tracking unit with status descriptions:

  • SELECT du_id, du_order_number, du_amount, du_currency_code, status_desc, tu_id FROM apps.igi_exp_dus_in_tus_v WHERE tu_id = :p_tu_id AND org_id = :p_org_id;

Filter by status meaning as surfaced by the search term:

  • SELECT du_id, du_order_number, status_desc, du_date FROM apps.igi_exp_dus_in_tus_v WHERE du_status = 'APPROVED' AND org_id = :p_org_id ORDER BY du_date DESC;

Currency-denominated aggregation for TU reporting:

  • SELECT du_currency_code, SUM(du_amount) total_du FROM apps.igi_exp_dus_in_tus_v WHERE tu_id = :p_tu_id GROUP BY du_currency_code;

Because the view presumes existing TU linkage and pre-joined reference data, it is preferable to ad hoc queries against IGI_EXP_DUS_ALL whenever TU-scoped DU data with decoded status and currency is required.