Search Results pymnt_per_start_date




Overview
Explore in AI Chat

Overview

IGF_SL_DB_COD_REP_V is an Oracle E-Business Suite database view owned by the APPS schema, residing in the IGF (Grants) product family. It exposes disbursement-related detail for awards processed through the grants disbursement cycle, specifically the cash-on-delivery (COD) reporting data set. In the context of Oracle EBS 12.1.1 and 12.2.2, the view functions as a reporting and integration layer that presents a flattened, presentation-ready projection of disbursement transaction records. Because it is a view rather than a table, it does not store data; it retrieves and formats rows from its single underlying base table at query time, applying string trimming and date-to-character conversion so that downstream consumers receive consistent, canonical output.

The view is particularly relevant when a user searches for the DISB_REL_FLAG column, since that column is among the exposed fields. The DISB_REL_FLAG indicates the release status or release indicator for an individual disbursement, allowing reports to distinguish disbursements that have been released from those that remain pending release.

Underlying Base Objects

According to the documented ETRM metadata, the view is defined over a single referenced base object: the table IGF_AW_DB_COD_DTLS. All columns selected by the view originate from that table, with no joins, unions, or external references. The documented view text is:

  • Source table: IGF_AW_DB_COD_DTLS
  • Owner: APPS
  • No additional referenced base objects are documented.

Because the view performs no joins, its row cardinality matches the underlying disbursement detail table filtered only by the standard view definition. The projection applies TRIM to the three descriptive identifier text columns and converts two date columns to the 'YYYY-MM-DD' character format, which normalizes output for reporting tools that prefer character strings over native DATE data types.

Key Columns

Common Use Cases and Queries

Typical scenarios include award disbursement reconciliation, release-status monitoring, and extract generation for downstream grants reporting. A representative query filtering on the searched column follows:

SELECT AWARD_ID, DISB_NUM, DISB_DATE, DISB_ACCEPTED_AMT, DISB_REL_FLAG, DISB_NET_AMT
FROM APPS.IGF_SL_DB_COD_REP_V
WHERE DISB_REL_FLAG = 'Y';

To review all disbursements for a specific award ordered by sequence:

SELECT DISB_NUM, DISB_SEQ_NUM, DISB_DATE, DISB_NET_AMT
FROM APPS.IGF_SL_DB_COD_REP_V
WHERE AWARD_ID = :award_id
ORDER BY DISB_SEQ_NUM;

Because the view already trims identifier text and formats dates as strings, it is well suited for flat-file extracts and interface programs where fixed formatting is required. Users should note that the release flag semantics and valid values should be confirmed against the underlying IGF_AW_DB_COD_DTLS column definition before relying on it for business logic.