Search Results du_currency




Overview
Explore in AI Chat

Overview

IGI_EXP_DUS_NOT_IN_TUS_V is an APPS-owned database view within the IGI - Public Sector Financials International product family. Its documented purpose is to display Dialog Units (DUs) that have not yet been assigned to any Transmission Unit (TU). The view is primarily consumed by the Oracle EBS form "Define Transmission Units," where it drives the list of available Dialog Units that an operator may attach to a Transmission Unit during the transmission-definition workflow.

In the Oracle EBS 12.1.1 and 12.2.2 architectures, the view functions as a read-only reporting and selection layer over the Dialog Unit transaction data stored in IGI_EXP_DUS. Because it filters out any Dialog Unit that already carries a TU_ID, it effectively exposes only unassigned or "open" Dialog Units. This makes it a practical source for concurrent programs, custom reports, and integration extracts that need to identify Dialog Units awaiting transmission grouping. The presence of the DU_CURRENCY column, derived from FND_CURRENCIES, also makes the view directly relevant to currency-based analysis of outstanding Dialog Units.

Underlying Base Objects

The view is defined over the following documented base objects and joined synonyms:

The defining filter IED.TU_ID IS NULL is the central predicate that distinguishes this view from the full Dialog Unit data set.

Key Columns

  • ROW_ID — the ROWID of the underlying IGI_EXP_DUS row, useful for DML targeting.
  • DU_ID — unique identifier of the Dialog Unit.
  • DU_TYPE_NAME — the Dialog Unit type classification from the type header.
  • DU_ORDER_NUMBER / DU_LEGAL_NUMBER — order and legal references for the Dialog Unit.
  • DU_CURRENCY — the currency description derived from FND_CURRENCIES, matching the user query term.
  • DU_CURRENCY_CODE — the corresponding ISO currency code.
  • STATUS_DESC — decoded Dialog Unit status meaning from IGI_LOOKUPS.
  • DU_AMOUNT / DU_PREPAY_AMOUNT — monetary values associated with the Dialog Unit.
  • TU_ID — retained for completeness but always NULL in this view by definition.
  • DU_DATE / DU_FISCAL_YEAR / PRINT_DATE — temporal attributes for period-based reporting.
  • DU_BY_USER_NAME — the user who created the Dialog Unit.
  • ATTRIBUTE_CATEGORY through ATTRIBUTE8+ — descriptive flexfield segments.

Common Use Cases and Queries

The most frequent scenario is populating a selection list in the Define Transmission Units form. Reporting users also extract unassigned Dialog Units by currency, status, or fiscal year for reconciliation and follow-up.

  • Unassigned Dialog Units by currency — filter on DU_CURRENCY_CODE or DU_CURRENCY.
  • Outstanding Dialog Units by status — group by STATUS_DESC to see pending versus approved DUs.
  • Fiscal-year aging — aggregate DU_AMOUNT by DU_FISCAL_YEAR.

Sample SQL:

SELECT du_currency, du_currency_code, status_desc,
  COUNT(*) du_count, SUM(du_amount) total_amount
FROM apps.igi_exp_dus_not_in_tus_v
WHERE du_fiscal_year = :p_fiscal_year
GROUP BY du_currency, du_currency_code, status_desc
ORDER BY du_currency;

Individual Dialog Unit lookup:

SELECT du_id, du_order_number, du_legal_number, du_currency,
  du_amount, status_desc, du_by_user_name
FROM apps.igi_exp_dus_not_in_tus_v
WHERE du_currency_code = 'USD'
  AND du_status = 'APPROVED';