Search Results step_type_restriction_num

Overview

IGS_AD_PRCS_CAT_STEP_V is a view in the Oracle E-Business Suite IGS (Student System) product family, which is documented as obsolete in ETRM 12.2.2. The view presents the configuration of admission processing category steps, exposing both step-level and tracking-level definitions in a single, union-based result set. It is designed to support reporting and integration scenarios that require a consolidated, denormalized listing of admission process categories, the steps assigned to each category, the associated lookup-driven meanings, and the sequencing attributes that govern step execution order. The column the user searched for, step_order_num, is exposed directly by this view and is one of its primary ordering attributes.

The view is also flagged in the ETRM metadata with the note "Not implemented in this database," indicating that it may not be present in every Oracle EBS instance and that availability depends on the installation level of the IGS product. The metadata further documents no owner and no referenced base objects, an indication of incomplete or superseded documentation for this obsolete object.

Underlying Base Objects

The view text is defined as a UNION of two SELECT statements, each drawing from the base table IGS_AD_PRCS_CAT_STEP (aliased APCS in both branches). The first branch joins to IGS_LOOKUPS_VIEW (LKUPV1) filtered on LOOKUP_TYPE = 'ADMISSION_STEP_TYPE', with additional join predicates on STEP_GROUP_TYPE, to retrieve step-type meanings, restriction indicators, and closed indicators. The second branch joins to IGS_TR_TYPE (TRT) and IGS_LOOKUP_VALUES (LKUPV2) to cover tracking-type rows, where the tracking type is resolved through the TRACKING_TYPE lookup. Although the ETRM summary lists "referenced base objects: none documented," the view text itself clearly identifies IGS_AD_PRCS_CAT_STEP, IGS_TR_TYPE, IGS_LOOKUPS_VIEW, and IGS_LOOKUP_VALUES as the operative sources. A literal STEP_GROUP_TYPE value of 'TRACK' differentiates the second branch from the first.

Key Columns

• ROW_ID — Identifier carried through from the base admission processing category step record.
• ADMISSION_CAT — Admission category to which the step belongs.
• S_ADMISSION_PROCESS_TYPE / S_ADMISSION_STEP_TYPE — Process type and step type associations.
• S_TRACKING_TYPE / S_TRK_MEANING / DESCRIPTION — Populated only in the tracking branch (second SELECT); NULL in the step-type branch.
• MEANING — Populated only in the first SELECT from the lookup view; NULL in the tracking branch.
• STEP_GROUP_TYPE — Either the stored group type from the base table or the literal 'TRACK'.
• STEP_TYPE_RESTRICTION_NUM_IND / STEP_TYPE_RESTRICTION_NUM — Indicators and numeric restriction values governing eligible step types.
• CLOSED_IND — Whether the step or tracking definition is closed.
• MANDATORY_STEP_IND — Whether the step is mandatory.
• STEP_ORDER_NUM — The ordinal position of the step within its category; the primary sequencing column returned by the view.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard audit columns.

Common Use Cases and Queries

Typical usage orders admission category steps for a given category and process type, filtering out closed or non-mandatory definitions as required.

SELECT admission_cat, s_admission_step_type, step_order_num
FROM igs_ad_prcs_cat_step_v
WHERE admission_cat = :category
ORDER BY step_order_num;

A second common pattern isolates tracking rows by filtering on the literal STEP_GROUP_TYPE = 'TRACK'. Analysts also correlate S_TRACKING_TYPE with the TRACKING_ lookup values to produce meaningful tracking labels in reporting extracts.

Because the object is obsolete and possibly not implemented, queries should be preceded by a check of ALL_VIEWS for IGS_AD_PRCS_CAT_STEP_V before being embedded in production integrations.