Search Results igs_as_doc_details_v




Overview
Explore in AI Chat

Overview

The IGS_AS_DOC_DETAILS_V view is a read-only database object owned by the APPS schema in Oracle E-Business Suite, part of the IGS (Student System) product family. It presents information about the documents associated with student orders processed through the Student System academic and administrative functions. In Oracle EBS 12.1.1 and 12.2.2, the view serves as a reporting and integration layer that consolidates document line detail — fees, recipient addressing, delivery method, included academic data, and hold/transcript flags — into a single queryable structure. Its status is VALID, indicating it is compiled and available for use by concurrent programs, OAF pages, forms, and custom reports across both releases.

Underlying Base Objects

The documented view text selects directly from a detail table aliased DTL, from which it projects the ROWID and a comprehensive list of columns. This detail table stores the transaction-level attributes of each document associated with an order, while the PLAN_ID column links the row back to the corresponding document plan or order header context. The ETRM metadata does not enumerate referenced base objects, but the column naming (PLAN_ID, ORDER_NUMBER, DOCUMENT_TYPE, and the INCL_* inclusion flags) strongly implies a parent document-plan table joined implicitly through PLAN_ID. As a view, it holds no independent storage; it inherits the security and read consistency of its base table and is typically queried with the APPS database credentials or through a secured synonym exposed to end users.

Key Columns

  • PLAN_ID / ORDER_NUMBER — Identifies the document plan and the order to which the document belongs.
  • NVL(OVERRIDDEN_DOC_DELIVERY_FEE, DELIVERY_FEE) and NVL(OVERRIDDEN_DOCUMENT_FEE, DOC_FEE_PER_COPY) — Present the effective delivery and document fees, substituting the overridden value where an operator has manually adjusted the charge; the raw and override columns are also exposed separately for audit.
  • FEE_OVERRIDDEN_BY / FEE_OVERRIDDEN_DATE — Capture the user and timestamp of any fee override.
  • DOCUMENT_TYPE / DOCUMENT_SUB_TYPE / DOC_PURPOSE_CODE — Classify the document (for example transcript or confirmation) and its purpose.
  • INCL_* columns — A large family of inclusion flags controlling whether department, field of study, attendance mode, awards, HESA number, program details, student name, and similar academic data are printed or transmitted.
  • RECIP_* columns — The full recipient address block, including lines 1–4, city, postal code, state, province, county, country, and fax details.
  • HOLD_* and FGRADE/DEGHOLD columns — Flags and calendar references governing release of final grades and degree holds.
  • NUM_OF_COPIES, ITEM_NUMBER, ITEM_STATUS, DATE_PRODUCED, DELIVERY_METHOD_TYPE — Production and fulfilment attributes.

Common Use Cases and Queries

Typical uses include transcript and document production reporting, fee reconciliation, and interface extracts feeding printing or mailing systems. A representative query for orders produced within a date range is:

SELECT plan_id, order_number, document_type,
       NVL(overridden_doc_delivery_fee, delivery_fee) effective_delivery_fee,
       NVL(overridden_document_fee, doc_fee_per_copy) effective_document_fee,
       recip_pers_name, recip_city, recip_country, date_produced
FROM   apps.igs_as_doc_details_v
WHERE  date_produced BETWEEN :p_from AND :p_to
AND    document_type = :p_type;

A second common pattern reviews fee overrides for audit purposes using fee_overridden_by and fee_overridden_date. Because the view exposes both raw and overridden fees, reconciliation reports can compare charged versus standard amounts without additional lookups.