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.IGSBV_AD_ADM_APPL

Object Details

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

View Type

A Business Intelligence System view

Describes Admission of Application to Institution

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PERSON_ID	NUMBER	(15)	Yes	Person Identifier
PERSON_NUMBER	VARCHAR2	(30)	Yes	Person Number
PERSON_NAME	VARCHAR2	(450)
ADMISSION_APPLICATION_NUMBER	NUMBER	(2)	Yes	Admission Application Number
APPLICATION_DATE	DATE		Yes
ACADEMIC_CALENDAR_TYPE	VARCHAR2	(10)	Yes	Academic Calendar Type
ACADEMIC_CAL_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Academic Calendar Sequence Number
ADMISSION_CALENDAR_TYPE	VARCHAR2	(10)	Yes	Admission Calendar Type
ADMISSION_CAL_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Admission Calendar Sequence Number
ADMISSION_CATEGORY	VARCHAR2	(10)	Yes	Admission Category for Admission Application
_LA:PROCESS_TYPE_MEANING	CHAR	(81)		Lookup Tag for Process Type
ADMISSION_APPLICATION_STATUS	VARCHAR2	(10)	Yes	Admission Application Status
ADMISSION_FEE_STATUS	VARCHAR2	(10)	Yes	Admission Fee Status
_LA:TAC_APPL_IND_FLAG	CHAR	(53)		Lookup Tag for Application Indicator
SPECIAL_GROUP_1	NUMBER			Special Group 1
SPECIAL_GROUP_2	NUMBER			Special Group 2
_LA:COMMON_APP_IND_FLAG	CHAR	(51)		Lookup Tag for Common Application Indicator
APPLICATION_TYPE	VARCHAR2	(30)		Admission Application Type
CHOICE_NUMBER	NUMBER	(3)		Choice Number
ROUTEB_PREF	VARCHAR2	(30)		Routeb B Preference
APPLICATION_ID	NUMBER	(15)		Application Id
ALTERNATE_APPLICATION_ID	VARCHAR2	(30)		Alternate Application Id
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

Query Text

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


SELECT PERSON_ID
,      PERSON_NUMBER
,      PERSON_NAME
,      ADMISSION_APPLICATION_NUMBER
,      APPLICATION_DATE
,      ACADEMIC_CALENDAR_TYPE
,      ACADEMIC_CAL_SEQUENCE_NUMBER
,      ADMISSION_CALENDAR_TYPE
,      ADMISSION_CAL_SEQUENCE_NUMBER
,      ADMISSION_CATEGORY
,      _LA:PROCESS_TYPE_MEANING
,      ADMISSION_APPLICATION_STATUS
,      ADMISSION_FEE_STATUS
,      _LA:TAC_APPL_IND_FLAG
,      SPECIAL_GROUP_1
,      SPECIAL_GROUP_2
,      _LA:COMMON_APP_IND_FLAG
,      APPLICATION_TYPE
,      CHOICE_NUMBER
,      ROUTEB_PREF
,      APPLICATION_ID
,      ALTERNATE_APPLICATION_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSBV_AD_ADM_APPL;

Dependencies

[top of page]

APPS.IGSBV_AD_ADM_APPL references the following:

APPS: HZ_PARTIES; HZ_PERSON_PROFILES; IGS_AD_APPL_ALL

APPS.IGSBV_AD_ADM_APPL is not referenced by any database object