Search Results package_item_desc

Overview

The IGR_I_ITYP_PKGS_V view is a reporting and integration object in the Oracle E-Business Suite Student System (IGS) product family. It is owned by the APPS schema and holds a VALID status in both EBS 12.1.1 and 12.2.2. The view resolves the relationship between information types and the package items they contain. In the IGS data model, an information type (also referred to as a deliverable kit) acts as a container that groups one or more package items (deliverable kit parts). This view flattens that hierarchical relationship into a single denormalized result set, exposing both the parent information type and each of its constituent package items with descriptive attributes joined from the Advanced Management System (AMS) deliverables layer.

Because the view joins IGS configuration tables to AMS deliverable views, it is typically used in reporting, validation, and integration scenarios where an application or concurrent program must determine which package items belong to a given information type, or conversely, which information types reference a given package item. The presence of OBJECT_VERSION_NUMBER and the standard WHO audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) indicates the view is compatible with Oracle Application Framework (OAF) based inquiries and any tooling that relies on optimistic locking metadata.

Underlying Base Objects

The view text is composed of five underlying objects. The IGR_I_PKG_ITEM table appears twice, aliased as INFOTYPE and PKGITM, representing the parent information type and the member package item respectively. Three AMS deliverable views supply descriptive content: AMS_P_DELIV_KIT_ITEMS_V (aliased KITEMS), and AMS_P_DELIVERABLES_V twice, aliased as DELIV and DELIV_KIT. The join conditions link INFOTYPE.PACKAGE_ITEM_ID to KITEMS.DELIVERABLE_KIT_ID and to DELIV_KIT.DELIVERABLE_ID, while PKGITM.PACKAGE_ITEM_ID joins to KITEMS.DELIVERABLE_KIT_PART_ID and to DELIV.DELIVERABLE_ID. The ETRM metadata records no separately documented base tables for this view, so the AMS and IGR objects referenced in the view text constitute the authoritative underlying set.

Key Columns

• ROW_ID — Unique row identifier sourced from KITEMS.ROW_ID, used as the primary reference key for the view row.
• DELIVERABLE_KIT_ITEM_ID — Identifier of the deliverable kit item record from which the row is derived.
• INFO_TYPE_ID — The information type identifier, aliased from INFOTYPE.PACKAGE_ITEM_ID.
• INFORMATION_TYPE — The kit name of the parent information type (KITEMS.KIT_NAME).
• INFORMATION_TYPE_DESC — Description of the parent information type from DELIV_KIT.DESCRIPTION.
• INFORMATION_TYPE_KIT_FLAG — Flag indicating whether the information type is itself treated as a kit (DELIV_KIT.KIT_FLAG).
• PACKAGE_ITEM_ID — Identifier of the member package item (PKGITM.PACKAGE_ITEM_ID).
• PACKAGE_ITEM — The kit part name representing the package item (KITEMS.KIT_PART_NAME).
• PACKAGE_ITEM_DESC — Description of the package item from DELIV.DESCRIPTION.
• PACKAGE_ITEM_KIT_FLAG — Flag indicating whether the package item is a kit.
• OBJECT_VERSION_NUMBER, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard audit and concurrency-control columns inherited from IGR_I_PKG_ITEM.

Common Use Cases and Queries

Typical usage includes reporting the full membership of an information type, validating setup before publishing deliverables, and feeding integration extracts. A representative query listing all package items for a specific information type is:

SELECT information_type
     , package_item
     , package_item_desc
  FROM apps.igr_i_ityp_pkgs_v
 WHERE info_type_id = :p_info_type_id
 ORDER BY package_item;

A reverse lookup identifies which information types contain a given package item:

SELECT DISTINCT information_type
  FROM apps.igr_i_ityp_pkgs_v
 WHERE package_item_id = :p_package_item_id;

Because the view exposes audit columns, it also supports change-detection queries filtering on LAST_UPDATE_DATE for incremental extraction into downstream reporting tables.