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_AS_UAI_EXAMINATION_V

Object Details

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

View Type

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

IGS_AS_UAI_EXAMINATION_V describes all examinations that are required within the
examination calendar instance in which they are to be examined.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
EXAM_CAL_TYPE	VARCHAR2	(10)	Yes	Examination calendar type
EXAM_CI_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Examination calendar instance sequence number
TEACH_CAL_TYPE	VARCHAR2	(10)	Yes	Teaching calendar type
TEACH_CI_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Teaching calendar instance sequence number
ASS_ID	NUMBER	(10)	Yes	Assessment identifier
UNIT_CD	VARCHAR2	(10)	Yes	Unit code
REFERENCE	VARCHAR2	(30)		Reference for unit assessment item
EXAM_PAPER_NAME	VARCHAR2	(90)		Examination paper name
OWNER_ORG_UNIT_CD	VARCHAR2	(30)	Yes	Owning organization unit code
EXAM_WORKING_TIME	DATE			Examination working time
EXAM_LOCATION_CD	VARCHAR2	(4000)		Examination location code
DEG_AUD_DETAIL_ID	NUMBER			Degree Audit Detail Id

Query Text

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


SELECT EXAM_CAL_TYPE
,      EXAM_CI_SEQUENCE_NUMBER
,      TEACH_CAL_TYPE
,      TEACH_CI_SEQUENCE_NUMBER
,      ASS_ID
,      UNIT_CD
,      REFERENCE
,      EXAM_PAPER_NAME
,      OWNER_ORG_UNIT_CD
,      EXAM_WORKING_TIME
,      EXAM_LOCATION_CD
,      DEG_AUD_DETAIL_ID
FROM APPS.IGS_AS_UAI_EXAMINATION_V;

Dependencies

[top of page]

APPS.IGS_AS_UAI_EXAMINATION_V references the following:

APPS: IGS_AS_ASSESSMNT_ITM; IGS_AS_GEN_003 - show dependent code; IGS_AS_SU_ATMPT_ITM; IGS_AS_UAI_EXAM_CI_V; IGS_AS_UNIT_CLASS; IGS_AS_VAL_UAI - show dependent code; IGS_CA_INST; IGS_CA_STAT; IGS_EN_GEN_014 - show dependent code; IGS_EN_SU_ATTEMPT; IGS_PS_UNIT_STAT; IGS_PS_UNIT_VER

APPS.IGS_AS_UAI_EXAMINATION_V is not referenced by any database object