Results for “crt_rev_instr”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGS_AD_SS_APPL_TYP_V is a reporting and integration view within the Oracle EBS Student System (IGS) module. In the ETRM documentation for releases 12.1.1 and 12.2.2, the product is flagged as Obsolete, and the implementation note records "Not implemented in this database." The view presents configuration and fee-related attributes for admission application types, joining base setup tables with lookups and form functions to deliver descriptive, human-readable output suitable for concurrent programs, Oracle Reports, OAF pages, and external integrations consuming admissions configuration data.

The view is directly relevant to the search term enroll_deposit_amount, which it exposes as a column, allowing reporting on the deposit amounts and deposit levels associated with each admission application type.

Underlying Base Objects

The view text documents the following base objects in its FROM clause:

• IGS_AD_SS_APPL_TYP SSA — the primary driver table holding self-service admission application type definitions.
• IGS_AD_CAT AC and IGS_AD_PRCS_CAT APC — admission category and admission process category tables, joined on ADMISSION_CAT and S_ADMISSION_PROCESS_TYPE.
• FND_FORM_FUNCTIONS_VL FFV — outer-joined on CONFIGURABILITY_FUNC_NAME to FUNCTION_NAME, resolving the user function name.
• IGS_LOOKUP_VALUES ILV — supplies the ADMISSION_PROCESS_TYPE meaning.
• IGS_LOOKUP_VALUES L2 — outer-joined on ENROLL_DEPOSIT_LEVEL with LOOKUP_TYPE = 'DEPOSIT_LEVELS', supplying the deposit level meaning.

ETRM records no documented referenced base objects for the view; the join relationships above are derived from the documented view text.

Key Columns

• ROW_ID — the ROWID of the underlying application type row.
• ADMISSION_APPLICATION_TYPE — primary identifier for the application type.
• ADMISSION_CAT / ADMISSION_PROCESS_CATEGORY — concatenation of category and process type meaning.
• APPLICATION_FEE_AMOUNT, GL_REV_ACCOUNT_CCID, GL_CASH_ACCT_CCID, CASH_ACCOUNT_CODE, REV_ACCOUNT_CODE — fee and accounting configuration.
• ENROLL_DEPOSIT_AMOUNT — the enrollment deposit amount configured for the application type.
• ENROLL_DEPOSIT_LEVEL / ENROLL_DEPOSIT_LEVEL_MEANING — deposit level code and its lookup meaning.
• CONFIGURABILITY_FUNC_NAME / CONFIG_FUNC_NAME_DESC — configurability function and its form function description.
• USE_IN_APPL_SELF_SRVC, CLOSED_IND, SYSTEM_DEFAULT — operational flags.
• CRT_REV_INSTR, SUBMIT_INSTR, SUBMIT_ERR_INSTR — instructional text fields.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.

Common Use Cases and Queries

Typical uses include reviewing fee and deposit configuration per application type, validating self-service availability, and extracting lookup-resolved descriptions for integrations.

Sample query returning deposit configuration for active application types:

• SELECT ADMISSION_APPLICATION_TYPE, DESCRIPTION, ENROLL_DEPOSIT_AMOUNT, ENROLL_DEPOSIT_LEVEL_MEANING, APPLICATION_FEE_AMOUNT FROM IGS_AD_SS_APPL_TYP_V WHERE CLOSED_IND = 'N' ORDER BY ADMISSION_APPLICATION_TYPE;

Query filtering on the searched attribute:

• SELECT ADMISSION_APPLICATION_TYPE, ENROLL_DEPOSIT_AMOUNT, ENROLL_DEPOSIT_LEVEL FROM IGS_AD_SS_APPL_TYP_V WHERE ENROLL_DEPOSIT_AMOUNT > 0;

Query listing self-service-enabled types with their configurability function:

• SELECT ADMISSION_APPLICATION_TYPE, CONFIG_FUNC_NAME_DESC, ADMISSION_PROCESS_CATEGORY FROM IGS_AD_SS_APPL_TYP_V WHERE USE_IN_APPL_SELF_SRVC = 'Y';

Because the module is documented as obsolete and the view is not implemented in the reference database, availability should be confirmed against the target instance before relying on these queries.