Search Results inq_prog_pkg_item_id




Overview
Explore in AI Chat

Overview

The IGS_AD_I_PRG_PKG_ITM table is a core data structure within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Admissions (IGS) module. It functions as a junction or mapping table that establishes relationships between inquiry program codes and specific inquiry package items. Its primary role is to define which standardized inquiry items (e.g., brochures, application forms, specific information packets) are associated with a particular academic inquiry program. This configuration is essential for managing the automated or semi-automated fulfillment of information requests from prospective students during the admissions lifecycle.

Key Information Stored

The table stores the linkage metadata and its lifecycle status. The critical columns are:

The unique constraint on the combination of INQ_PROG_CODE_ID and ENQUIRY_PACKAGE_ITEM (IGS_AD_I_PRG_PKG_ITM_U2) ensures a program cannot be linked to the same item more than once.

Common Use Cases and Queries

A primary use case is generating reports or lists of all information package items required for a specific inquiry program, often for operational checklists or fulfillment system interfaces. Another is validating or auditing configuration setup. The user's search for "inq_prog_pkg_item_id" suggests direct interaction with this key identifier, likely for data retrieval or integration purposes. Common query patterns include fetching all active items for a program or finding which programs use a specific item.

Sample Query: Retrieve all active package items for a specific Inquiry Program Code ID.

SELECT ipi.enquiry_package_item,
       ipi.closed_ind
FROM igs.igs_ad_i_prg_pkg_itm ipi
WHERE ipi.inq_prog_code_id = :p_inq_prog_code_id
AND NVL(ipi.closed_ind, 'N') = 'N'
ORDER BY ipi.enquiry_package_item;

Sample Query: Find the primary key (INQ_PROG_PKG_ITEM_ID) for a specific program-item mapping.

SELECT inq_prog_pkg_item_id
FROM igs.igs_ad_i_prg_pkg_itm
WHERE inq_prog_code_id = :p_prog_code_id
AND enquiry_package_item = :p_package_item;

Related Objects

The table's integrity is maintained through defined foreign key relationships, integrating it into the broader Admissions data model.

  • Primary Key Reference: The table's PK (INQ_PROG_PKG_ITEM_ID) is referenced by other objects in the APPS schema, as indicated in the dependencies, though specific object names are not listed in the provided excerpt.
  • Foreign Key Dependencies (This table references):
    • TABLE: IGS.IGS_AD_INQ_PROGS via column INQ_PROG_CODE_ID. This joins to the master definition of inquiry programs.
    • TABLE: IGS.IGS_IN_ENQ_PKG_ITEM via column ENQUIRY_PACKAGE_ITEM. This joins to the master list of available inquiry package items.

These relationships are critical for any join query that requires descriptive information about the program or the item beyond their identifiers.