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_PS_APLCNTX_LKUP_V

Object Details

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

View Type

A public view which may be useful for custom reporting or other data
requirements.

View of IGS_AD_PS_APPL_APLCNTX_V for forms, requiring this table as a context block - Obsolete as part of bug 2264039

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PERSON_ID	NUMBER	(15)	Yes	Person identifier and foreign key to HZ_PARTIES. This is a sequence generated value.
ADMISSION_APPL_NUMBER	NUMBER	(2)	Yes	Admission application number
NOMINATED_COURSE_CD	VARCHAR2	(6)	Yes	Nominated program code
CONTEXT_BLOCK_NAME	VARCHAR2	(455)		Full name of person
SEX	VARCHAR2	(30)		Sex code
MEANING_SEX	VARCHAR2	(80)		Meaning of the sex code
BIRTH_DT	DATE			Birth date of person
ENCUMBERED_IND	VARCHAR2	(4000)		Flag to show whether holds exist on the person
DECEASED_IND	VARCHAR2	(1)		Deceased indicator
COMMENCEMENT_PERIOD	VARCHAR2	(21)		Describes the commencement period the admission applicationis applicable for
ADMISSION_PROCESS_CAT	VARCHAR2	(91)		Describes the admission process category of the admission application
TITLE	VARCHAR2	(90)	Yes	Title of the person
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column

Query Text

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


SELECT PERSON_ID
,      ADMISSION_APPL_NUMBER
,      NOMINATED_COURSE_CD
,      CONTEXT_BLOCK_NAME
,      SEX
,      MEANING_SEX
,      BIRTH_DT
,      ENCUMBERED_IND
,      DECEASED_IND
,      COMMENCEMENT_PERIOD
,      ADMISSION_PROCESS_CAT
,      TITLE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM APPS.IGS_AD_PS_APLCNTX_LKUP_V;

Dependencies

[top of page]

APPS.IGS_AD_PS_APLCNTX_LKUP_V references the following:

APPS: FND_LOOKUP_VALUES; IGS_AD_PS_APPL_APLCNTX_V; IGS_EN_GEN_003 - show dependent code; IGS_EN_GEN_007 - show dependent code

APPS.IGS_AD_PS_APLCNTX_LKUP_V is not referenced by any database object