Results for “function_description”
1 result
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The IGSFV_AD_ADM_APPL_TYP view is a self-service reporting object within the Oracle E-Business Suite Student System (IGS) product family. It is owned by the APPS schema and is defined with the WITH READ ONLY clause, meaning it is intended exclusively for query and reporting purposes. The view exposes admission application type definitions together with their associated general ledger accounting flexfield references and descriptive attributes.
Its role within EBS is to provide a single denormalized source of admission application type configuration data, resolving foreign keys into human-readable descriptions. This makes it suitable for both end-user reporting tools (such as Oracle BI Publisher, Discoverer, or custom OAF pages) and integration extracts that need to present application type configuration without joining the base tables individually. The view is registered in ETRM with a status of VALID.
Underlying Base Objects
The view is defined over four documented base objects:
IGS_AD_SS_APPL_TYP APT— the primary self-service admission application type table, supplying most columns.IGS_AD_CAT_ALL AC— the admission category table, joined onADMISSION_CATto supply the category description.FND_FORM_FUNCTIONS_VL FF— the applications form functions view, outer-joined onCONFIGURABILITY_FUNC_NAME = FF.FUNCTION_NAMEto resolve the configuration function into a user function name and description.GL_CODE_COMBINATIONS_KFV KFV1andKFV2— the key flexfield concatenated-segments views, outer-joined twice to the revenue account CCID and the cash account CCID respectively. These joins supply theCONCATENATED_SEGMENTSdisplayed account strings.
Notably, the metadata documents no referenced base objects separately from those visible in the view text; the joins above are the authoritative relationships. Because the GL joins are outer joins (note the (+) operators), records with null or invalid account CCIDs still appear, with null concatenated segments.
Key Columns
ADMISSION_APPLICATION_TYPEandAPPLICATION_TYPE_DESC— the application type identifier and description.ADMISSION_CATEGORYandADMISSION_CATEGORY_DESC— the category code and its description fromIGS_AD_CAT_ALL.GL_REVENUE_ACCOUNT_CCID/GL_REVENUE_ACCOUNT_NAME— the revenue accounting flexfield CCID and its concatenated segment string (from KFV1).GL_CASH_ACCOUNT_CCID/GL_CASH_ACCOUNT_NAME— the cash accounting flexfield CCID and concatenated segments (from KFV2).REVENUE_ACCOUNT_CODEandCASH_ACCOUNT_CODE— legacy code references retained for backward compatibility.APPLICATION_FEE_AMOUNTandENROLLMENT_DEPOSIT_AMOUNT— fee and deposit amounts associated with the application type.CONFIGURABILITY_FUNCTION_NAME,USER_FUNCTION_NAME,FUNCTION_DESCRIPTION— configuration function details fromFND_FORM_FUNCTIONS_VL.- Descriptive lookup translations expressed as Flexfield/LOV alias columns, e.g.
_LA:APT.S_ADMISSION_PROCESS_TYPE,_LA:APT.CLOSED_IND, and_LA:APT.ENROLL_DEPOSIT_LEVEL, which map toIGS_LOOKUP_VALUESmeaning descriptions. - Audit columns (
CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE) and instructional text columns (CRT_REV_INSTR,SUBMIT_INSTR,SUBMIT_ERR_INSTR).
Common Use Cases and Queries
A frequent requirement is to retrieve the revenue and cash account concatenated strings for a given application type — a task that the user search term gl_code_combinations_kfv reflects directly, since this view embeds two references to that key flexfield view.
SELECT admission_application_type,
application_type_desc,
gl_revenue_account_name,
gl_cash_account_name,
application_fee_amount
FROM apps.igsfv_ad_adm_appl_typ
WHERE admission_category = 'UNDERGRAD';
Reporting scenarios include validating that every active application type has a valid revenue and cash account configured (identifying rows where the concatenated name is null), and building configuration extracts for review by the finance and admissions teams. Because the object is read-only, it can be safely queried in custom concurrent programs, BI Publisher data templates, and OAF view objects without risk of DML.
-
View: IGSFV_AD_ADM_APPL_TYP 12.1.1
Describes Self Service Admission Application Type Details
APPS.IGSFV_AD_ADM_APPL_TYP·↳ FND_FORM_FUNCTIONS_VL·↳ GL_CODE_COMBINATIONS_KFV·↳ IGS_AD_CAT_ALL·Explore IGS module →