Search Results delivery_method

Overview

The view IGSFV_AS_DOCUMENT_DETAILS belongs to the IGS – Student System product family within Oracle E-Business Suite. It is documented in ETRM for releases 12.1.1 and 12.2.2 and is classified as Obsolete. The view presents information about the documents associated with an academic order — typically transcripts, enrollment certifications, and similar student records dispatched to recipients. Its primary role is to expose document-level detail for reporting, inquiry, and integration scenarios where a flattened, denormalized projection of document attributes is more convenient than querying the underlying order and document tables directly.

In the context of the search term delivery_method, this view is relevant because it carries the delivery-related attributes of an academic document, such as express mail type, tracking number, fax numbers, and recipient address details. These columns collectively describe how a document is transmitted and where it is sent.

Underlying Base Objects

ETRM metadata for IGSFV_AS_DOCUMENT_DETAILS records no owner and no referenced base objects. The view text, however, confirms that it is defined over an aliased source TIINFO, which corresponds to the Academic Schedule / document information entity in the IGS schema. The definition is a direct projection of columns from that source, with no joins or aggregations, and several columns are emitted as literal lookup expressions using the _LA: convention. Those pseudo-columns instruct the EBS framework to resolve lookup values at runtime against the IGS_LOOKUP_VALUES table:

• IGS_AS_DOCUMENT_TYPE for the document type meaning
• IGS_AS_DOCUMENT_SUB_TYPE for the document sub-type meaning
• IGS_AS_ITEM_STATUS for the item status meaning

Because the base object is not implemented in the documented database, the view should be treated as legacy. It will not exist in all environments and should not be relied upon in new development.

Key Columns

The view exposes a broad set of document attributes. Representative columns include:

• ITEM_NUMBER, ORDER_NUMBER — identifiers linking the document to its originating order.
• DOCUMENT_TYPE, DOCUMENT_SUB_TYPE, ITEM_STATUS — lookup-driven classifications, surfaced as meanings.
• DATE_PRODUCED, NUM_OF_COPIES, INCL_CURR_COURSE — production and content indicators.
• RECIP_* columns — recipient name, institution, address lines, city, postal code, state, province, county, country, and fax area/country/number.
• EXPRESS_MAIL_TYPE, EXPRESS_MAIL_TRACK_NUM — courier-based delivery attributes.
• SEND_TRANSCRIPT_IMMEDIATELY, HOLD_* flags — dispatch handling and release holds.
• INCL_* flags — the content options included in the document, such as GPA, class rank, degree dates, majors, and hours earned.
• DUP_REQUESTED, DUP_REQ_DATE, DUP_SENT_DATE — duplicate handling.
• COMMENTS, EXTERNAL_COMMENTS, INTERNAL_COMMENTS, SPECIAL_INSTR — free-text annotations.

Together these columns describe both the content and the routing of the document.

Common Use Cases and Queries

Typical uses include auditing how documents are delivered, verifying recipient details, and reconciling duplicate requests. A representative query is:

SELECT order_number,
       item_number,
       document_type,
       express_mail_type,
       express_mail_track_num,
       recip_pers_name,
       recip_city,
       recip_country,
       date_produced
FROM   igsfv_as_document_details
WHERE  order_number = :p_order_number;

To isolate courier deliveries, filter on express_mail_type IS NOT NULL. Because the view is obsolete and not implemented in the documented database, confirm its availability before use and prefer supported IGS document inquiry APIs or current tables where the object is absent.