Search Results disb_accepted_amt




Overview
Explore in AI Chat

Overview

APPS.IGF_AW_DB_COD_DTLS_V is a reporting view in the Oracle E-Business Suite Grants Accounting and disbursement module (IGF). The name decodes as "IGF Award Disbursement Coded Details View." It exposes disbursement detail records that have been coded and validated against an award, making them available for downstream reporting, reconciliation, and integration. Within the Oracle EBS 12.1.1 and 12.2.2 environments, the view serves as a simplified, read-oriented projection of disbursement line data that supports federal grant processing workflows, particularly where disbursement authorization, acceptance, and confirmation tracking are required.

The view does not add joins or business transformations to its source; it is a straight column-level projection. This makes it a stable interface for custom reports, extracts, and interfaces that need to query disbursement detail without embedding knowledge of the physical table's full column set.

Underlying Base Objects

The view is defined exclusively over the base table IGF_AW_DB_COD_DTLS. The ETRM metadata does not document any additional referenced base objects, and the view text confirms a single-table SELECT with no joins, unions, or subqueries. Every column in the view maps one-to-one with a column of the same name in the base table, with the addition of the pseudo-column ROWID, which is included to preserve row-level addressing for update or row identification purposes.

Because the projection is one-to-one, the view inherits the base table's partitioning, indexing, and security characteristics. Access is governed by the APPS schema and dependent on the base table's grants. No distinct object owner is documented beyond the APPS schema under which the view is exposed.

Key Columns

Common Use Cases and Queries

The view is most commonly queried for award disbursement reporting filtered by disbursement date. A typical query:

  • SELECT award_id, disb_num, disb_date, disb_net_amt FROM apps.igf_aw_db_cod_dtls_v WHERE disb_date BETWEEN :p_from AND :p_to ORDER BY disb_date;
  • Award-level aggregation: SELECT award_id, SUM(disb_net_amt) net_total FROM apps.igf_aw_db_cod_dtls_v WHERE disb_date >= :p_start GROUP BY award_id;
  • Confirmation and release monitoring: SELECT document_id_txt, disb_date, disb_conf_flag, disb_rel_flag FROM apps.igf_aw_db_cod_dtls_v WHERE disb_conf_flag = 'N';

Because the view retains ROWID, it can also be used where row-level identification against the base table is required. All queries should respect the view's dependency on base table privileges and any grants-based security applying to IGF_AW_DB_COD_DTLS.