Search Results b_last_name




Overview
Explore in AI Chat

Overview

APPS.IGF_SL_DL_MANIFEST is a reporting view in the Oracle E-Business Suite (EBS) 12.1.1 / 12.2.2 environment, owned by the APPS schema and registered under FND Design Data as IGF.IGF_SL_DL_MANIFEST. It belongs to the Oracle Student Financial Aid / Institutional Grants and Federal Aid (IGF) product family, specifically the Student Loan (SL) sub-module that handles disbursement (DL) processing. The view presents manifest records that accompany student loan disbursement batches, exposing loan identifiers, borrower identity attributes, and processing status in a single flattened structure.

The view is defined as a multi-org view, meaning it retrieves only the rows associated with the operating unit (ORG_ID) of the current session and suppresses data belonging to other operating units. This behavior is implemented through the standard EBS Multi-Org security mechanism applied to the APPS-owning layer, and it makes the view suitable for use in concurrent programs, Oracle Reports, Oracle XML Publisher templates, and BI Publisher data models where operating-unit scoping is required.

Underlying Base Objects

According to the documented metadata, VIEW: APPS.IGF_SL_DL_MANIFEST references APPS.IGF_SL_DL_MANIFEST_ALL. The "_ALL" naming convention is the standard pattern used throughout EBS for multi-org tables: the _ALL table stores rows for every operating unit, and the non-_ALL view applies the ORG_ID predicate so that each operating unit sees only its own records. The manifest view therefore acts as the operating-unit-filtered projection of the underlying disbursement manifest data.

The metadata further shows that IGF_SL_DL_MANIFEST is referenced by APPS.IGF_SL_DL_MANIFEST_V and by APPS.IGF_SL_DL_PRINT_MANIFEST. This indicates the view is a building block for downstream presentation and print logic. The _V object is typically a validation / lookup view used for list-of-values and form-field validation, while IGF_SL_DL_PRINT_MANIFEST supplies data to the manifest printing process, where borrower names, Social Security Numbers, and loan numbers are laid out for printed or electronic disbursement manifests. Because dependent code exists below these references, changes to the view's column list or datatypes would propagate to those dependents.

Key Columns

The view exposes identifiers, borrower demographics, and audit columns, including the column the user searched for:

  • B_LAST_NAME (VARCHAR2 150) — the borrower's last name. The "B_" prefix denotes "Borrower," distinguishing it from any co-borrower or institutional name fields elsewhere in the data model.
  • B_FIRST_NAME, B_MIDDLE_NAME, B_SSN — the remaining borrower identity attributes used for matching, printing, and reconciliation against loan origination records.
  • PNMN_ID, BATCH_SEQ_NUM — the promissory note / manifest identifier and the sequence of the record within a disbursement batch.
  • LOAN_ID, LOAN_NUMBER — the internal loan surrogate key and the human-readable loan number.
  • STATUS — the processing state of the manifest record (for example, pending, transmitted, or acknowledged).
  • ORG_ID — the operating unit key driving the multi-org filter.
  • ROW_ID (ROWID) — the physical row identifier, useful for row-level operations and de-duplication.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — the standard EBS "WHO" audit columns, identifying the user and concurrent program that created or last modified each row.

Common Use Cases and Queries

Typical usage includes verifying which borrowers appear on a disbursement manifest, reconciling manifest rows against loan records, and generating print-ready extracts. Because the view is multi-org aware, queries should be run with the correct operating unit context.

List borrowers on all manifests for the current operating unit:

  • SELECT LOAN_NUMBER, B_LAST_NAME, B_FIRST_NAME, B_SSN, STATUS FROM APPS.IGF_SL_DL_MANIFEST ORDER BY B_LAST_NAME;

Locate a specific borrower by last name:

  • SELECT LOAN_NUMBER, B_FIRST_NAME, B_MIDDLE_NAME, B_LAST_NAME, STATUS FROM APPS.IGF_SL_DL_MANIFEST WHERE B_LAST_NAME = :last_name;

Count records by status for a disbursement batch:

  • SELECT BATCH_SEQ_NUM, STATUS, COUNT(*) FROM APPS.IGF_SL_DL_MANIFEST GROUP BY BATCH_SEQ_NUM, STATUS;

Trace processing history using audit columns:

  • SELECT LOAN_NUMBER, B_LAST_NAME, REQUEST_ID, PROGRAM_ID, LAST_UPDATE_DATE FROM APPS.IGF_SL_DL_MANIFEST WHERE REQUEST_ID = :request_id;

All queries should honor the operating unit implied by ORG_ID, since the view automatically excludes rows outside the current session's organization.