eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.IGSFV_AD_ADM_APPL_TYP

Object Details

Object Name:	IGSFV_AD_ADM_APPL_TYP
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGS.IGSFV_AD_ADM_APPL_TYP
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ADMISSION_APPLICATION_TYPE	VARCHAR2	(30)	Yes	Admission Application Type
APPLICATION_TYPE_DESC	VARCHAR2	(60)		Application Type Description
ADMISSION_CATEGORY	VARCHAR2	(10)	Yes	Admission Category
ADMISSION_CATEGORY_DESC	VARCHAR2	(60)	Yes	Description of an institution-defined admission category. An admission category is used to group a set of applicants whose applications will be processed by a common set of admission procedure steps.
_LA:PROCESS_TYPE_MEANING	CHAR	(81)		Lookup tag for Process Type
CONFIGURABILITY_FUNCTION_NAME	VARCHAR2	(30)		Configurability Function name attached to this Application Type
USER_FUNCTION_NAME	VARCHAR2	(80)		User name for that Configurability Function
FUNCTION_DESCRIPTION	VARCHAR2	(240)		Description for that Configurability Function
APPLICATION_FEE_AMOUNT	NUMBER	(13)		Application fee Amount
GL_REVENUE_ACCOUNT_CCID	NUMBER	(15)		Code Combination Id for GL Revenue Account
GL_REVENUE_ACCOUNT_NAME	VARCHAR2	(155)		Name for GL Revenue Account
GL_CASH_ACCOUNT_CCID	NUMBER	(15)		Code Combination Id for GL Cash Account
GL_CASH_ACCOUNT_NAME	VARCHAR2	(155)		Name for GL Cash Account
REVENUE_ACCOUNT_CODE	VARCHAR2	(40)		User Defined Revenue Account Code
CASH_ACCOUNT_CODE	VARCHAR2	(40)		User Defined Cash Account Code
_LA:CLOSED_IND_FLAG	CHAR	(51)		Closed Indicator
CREATED_BY	NUMBER	(15)	Yes	WHO column
CREATION_DATE	DATE		Yes	WHO column
LAST_UPDATED_BY	NUMBER	(15)	Yes	WHO column
LAST_UPDATE_DATE	DATE		Yes	WHO column
ENROLLMENT_DEPOSIT_AMOUNT	NUMBER	(13)		Enrollment Deposit Amount
_LA:DEPOSIT_LEVEL_MEANING	CHAR	(69)		Enrollment Deposit Level Lookup Tag
SYSTEM_DEFAULT	VARCHAR2	(1)		Indicates whether this Application Type is System Default
CRT_REV_INSTR	VARCHAR2	(600)		Create and Review Instruction
SUBMIT_INSTR	VARCHAR2	(600)		Submit Application Instruction
SUBMIT_ERR_INSTR	VARCHAR2	(600)		Submit Error Instruction

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ADMISSION_APPLICATION_TYPE
,      APPLICATION_TYPE_DESC
,      ADMISSION_CATEGORY
,      ADMISSION_CATEGORY_DESC
,      _LA:PROCESS_TYPE_MEANING
,      CONFIGURABILITY_FUNCTION_NAME
,      USER_FUNCTION_NAME
,      FUNCTION_DESCRIPTION
,      APPLICATION_FEE_AMOUNT
,      GL_REVENUE_ACCOUNT_CCID
,      GL_REVENUE_ACCOUNT_NAME
,      GL_CASH_ACCOUNT_CCID
,      GL_CASH_ACCOUNT_NAME
,      REVENUE_ACCOUNT_CODE
,      CASH_ACCOUNT_CODE
,      _LA:CLOSED_IND_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      ENROLLMENT_DEPOSIT_AMOUNT
,      _LA:DEPOSIT_LEVEL_MEANING
,      SYSTEM_DEFAULT
,      CRT_REV_INSTR
,      SUBMIT_INSTR
,      SUBMIT_ERR_INSTR
FROM APPS.IGSFV_AD_ADM_APPL_TYP;

Dependencies

[top of page]

APPS.IGSFV_AD_ADM_APPL_TYP references the following:

APPS: FND_FORM_FUNCTIONS_VL; GL_CODE_COMBINATIONS_KFV; IGS_AD_CAT_ALL; IGS_AD_SS_APPL_TYP

APPS.IGSFV_AD_ADM_APPL_TYP is not referenced by any database object