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

Object Details

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

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)
PERSON_ID	NUMBER	(15)	Yes	This field describes the ID of the person that the admission application is for.
PERSON_NUMBER	VARCHAR2	(30)	Yes
DSP_CONTEXT_BLOCK_NAME	VARCHAR2	(455)		Full Name of the person
ADMISSION_APPL_NUMBER	NUMBER	(2)	Yes	This field uniquely identifies an admission application for a person.
APPL_DT	DATE		Yes	This field describes the date the admission application was made.
ACAD_CAL_TYPE	VARCHAR2	(10)	Yes	This field describes the academic calendar type to which the admission application applies.
ACAD_CI_SEQUENCE_NUMBER	NUMBER	(6)	Yes	This field describes the academic calendar sequence number that the admission application is for.
ACAD_ALTERNATE_CODE	VARCHAR2	(10)		The alternate short reference code for identifying a teaching or academic calendar instance. This code is used for mass keying of enrolments and unit/course offerings.
ACAD_CI_START_DT	DATE		Yes	The date from which a calendar instance becomes effective. For example, the calendar instance Semester 1 1999 may commence on 1/3/1999.
ACAD_CI_END_DT	DATE		Yes	The date from which a calendar instance is no longer effective. For example, the calendar instance Semester 1 1999 may end on 11/6/1999.
ADM_CAL_TYPE	VARCHAR2	(10)	Yes	This field describes the admission calendar type to which the admission application applies.
ADM_CI_SEQUENCE_NUMBER	NUMBER	(6)	Yes	This field describes the admission calendar sequence number that the admission application is for.
ADM_ALTERNATE_CODE	VARCHAR2	(10)		The alternate short reference code for identifying a teaching or academic calendar instance. This code is used for mass keying of enrolments and unit/course offerings.
ADM_CI_START_DT	DATE		Yes	The date from which a calendar instance becomes effective. For example, the calendar instance Semester 1 1999 may commence on 1/3/1999.
ADM_CI_END_DT	DATE		Yes	The date from which a calendar instance is no longer effective. For example, the calendar instance Semester 1 1999 may end on 11/6/1999.
ADMISSION_CAT	VARCHAR2	(10)	Yes	This field describes the institution-defined admission category of the admission application.
S_ADMISSION_PROCESS_TYPE	VARCHAR2	(30)	Yes	This field describes the system-defined admission process type of the admission application.
ADM_PRC_TYPE_DESC	VARCHAR2	(80)	Yes
ADM_APPL_STATUS	VARCHAR2	(10)	Yes	This field describes the institution-defined application status of the admission application.
ADM_FEE_STATUS	VARCHAR2	(10)	Yes	This field describes the institution-defined fee status of the admission application.
TAC_APPL_IND	VARCHAR2	(1)	Yes	This field describes whether or not the application is via a Tertiary Admission Centre.
COMMENCEMENT_PERIOD	VARCHAR2	(21)		This field describes the commencement period the admission application is applicable for.
ADMISSION_PROCESS_CAT	VARCHAR2	(91)		This field describes the admission process category of the admission application.
ADM_APPL_STATUS_DISPLAY	VARCHAR2	(10)	Yes	This field describes the institution-defined application status of the admission application.
ADM_FEE_STATUS_DISPLAY	VARCHAR2	(10)	Yes	This field describes the institution-defined fee status of the admission application.
COMMON_APP	VARCHAR2	(1)
SPCL_GRP_1	NUMBER
SPCL_GRP_1_NAME	VARCHAR2	(10)
SPCL_GRP_1_DESC	VARCHAR2	(30)
SPCL_GRP_2	NUMBER
SPCL_GRP_2_NAME	VARCHAR2	(10)
SPCL_GRP_2_DESC	VARCHAR2	(30)
CREATED_BY	NUMBER	(15)	Yes
CREATION_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATE_LOGIN	NUMBER	(15)
APPLICATION_TYPE	VARCHAR2	(30)
CHOICE_NUMBER	NUMBER	(3)		Choice number
ROUTEB_PREF	VARCHAR2	(30)		Route B preference
APPLICATION_ID	NUMBER	(15)		Application Identifier
ALT_APPL_ID	VARCHAR2	(30)		Alternate Application Identifier
APPL_FEE_AMT	NUMBER			Application Fee Amount

Query Text

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


SELECT ROW_ID
,      PERSON_ID
,      PERSON_NUMBER
,      DSP_CONTEXT_BLOCK_NAME
,      ADMISSION_APPL_NUMBER
,      APPL_DT
,      ACAD_CAL_TYPE
,      ACAD_CI_SEQUENCE_NUMBER
,      ACAD_ALTERNATE_CODE
,      ACAD_CI_START_DT
,      ACAD_CI_END_DT
,      ADM_CAL_TYPE
,      ADM_CI_SEQUENCE_NUMBER
,      ADM_ALTERNATE_CODE
,      ADM_CI_START_DT
,      ADM_CI_END_DT
,      ADMISSION_CAT
,      S_ADMISSION_PROCESS_TYPE
,      ADM_PRC_TYPE_DESC
,      ADM_APPL_STATUS
,      ADM_FEE_STATUS
,      TAC_APPL_IND
,      COMMENCEMENT_PERIOD
,      ADMISSION_PROCESS_CAT
,      ADM_APPL_STATUS_DISPLAY
,      ADM_FEE_STATUS_DISPLAY
,      COMMON_APP
,      SPCL_GRP_1
,      SPCL_GRP_1_NAME
,      SPCL_GRP_1_DESC
,      SPCL_GRP_2
,      SPCL_GRP_2_NAME
,      SPCL_GRP_2_DESC
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      APPLICATION_TYPE
,      CHOICE_NUMBER
,      ROUTEB_PREF
,      APPLICATION_ID
,      ALT_APPL_ID
,      APPL_FEE_AMT
FROM APPS.IGS_AD_APPL_ADMAPPL_V;

Dependencies

[top of page]

APPS.IGS_AD_APPL_ADMAPPL_V references the following:

APPS: HZ_PARTIES; IGS_AD_APPL; IGS_AD_CODE_CLASSES; IGS_CA_INST; IGS_LOOKUP_VALUES

APPS.IGS_AD_APPL_ADMAPPL_V is referenced by following:

APPS: IGS_AD_ACK_LETTER_V; IGS_AD_GEN_010 - show dependent code; IGS_AD_INTERVIEW_LETTERS_V; IGS_AD_OUTCOME_LETTERS_V; IGS_AD_PS_APPL_APLCNTX_V