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_DA_XML_COURSEINSTITUTION_V

Object Details

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

View Type

A Web view designed to simplify access from Oracle Self-Service Web Applications.

XML element CourseInstitutionTypeProvides the Unit"s Institution code based on the batch_id, person_id and local_institution_cd.

[View Source]

Columns

Name	Datatype	Length	Comments
BATCH_ID	NUMBER		Contains the OSS generated Batch ID for tracking purposes.
PERSON_ID	NUMBER	(15)	Describes the details of the person ID code that is being passed.
INSTITUTION_CD	VARCHAR2	(30)	Describes an institution from which the transfer evaluation will be limited. The Institution is composed of the EntityID type. See this type for institution details.
LOCAL_INSTITUTION_CD	VARCHAR2	(30)	Describes the academic history of the student.

Query Text

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


SELECT BATCH_ID
,      PERSON_ID
,      INSTITUTION_CD
,      LOCAL_INSTITUTION_CD
FROM APPS.IGS_DA_XML_COURSEINSTITUTION_V;

Dependencies

[top of page]

APPS.IGS_DA_XML_COURSEINSTITUTION_V references the following:

APPS: FND_PROFILE - show dependent code; HZ_EDUCATION; HZ_PARTIES; IGS_AD_TERM_DETAILS; IGS_AD_TERM_UNITDTLS; IGS_AD_TRANSCRIPT; IGS_AV_STND_UNIT_ALL; IGS_DA_CNFG_REQ_TYP; IGS_DA_REQ_FTRS; IGS_DA_RQST; IGS_EN_STDNT_PS_ATT; IGS_EN_SU_ATTEMPT_ALL; IGS_OR_INST_ORG_BASE_V; IGS_PS_PRG_UNIT_REL; IGS_PS_UNIT_VER; IGS_PS_VER_ALL

APPS.IGS_DA_XML_COURSEINSTITUTION_V is not referenced by any database object