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

Object Details

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

View Type

A Business Intelligence System view

Full View for condition details that makes up the offer

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
CONDITION_CATEGORY	VARCHAR2	(450)	Yes	Condition Category
CONDITION_NAME	VARCHAR2	(450)	Yes	Condition Name
CONDITION_LINE	NUMBER	(3)	Yes	Line number for condition name
ABBREVIATION_CODE	VARCHAR2	(10)		Offer abbreviation code
GRADE_MARK	VARCHAR2	(10)		Grade or Mark
POINTS	VARCHAR2	(10)		Point score
SUBJECT_CODE	VARCHAR2	(10)		SUBJECT_CODE
CONDITION_TEXT	VARCHAR2	(60)		Condition free text
STATUS	VARCHAR2	(1)	Yes	Condition status
_LA:STATUS_DESC	CHAR	(59)
MARVIN_CODE	VARCHAR2	(591)		Marvin coded offer
SUMMARY_OF_CONDITIONS	VARCHAR2	(6)		Summary of Conditions
DECISION	VARCHAR2	(1)	Yes	UCAS Decision (U- unconditional offer, C - conditional offer, I - interview, W - withdrawal)
ABBREVIATION_TEXT	VARCHAR2	(250)		Abbreviation description
SUBJECT_TEXT	VARCHAR2	(300)		Subject description
CREATED_BY	NUMBER	(15)	Yes	Standard WHO columns
CREATION_DATE	DATE		Yes	Standard WHO columns
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO columns
LAST_UPDATE_DATE	DATE		Yes	Standard WHO columns

Query Text

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


SELECT CONDITION_CATEGORY
,      CONDITION_NAME
,      CONDITION_LINE
,      ABBREVIATION_CODE
,      GRADE_MARK
,      POINTS
,      SUBJECT_CODE
,      CONDITION_TEXT
,      STATUS
,      _LA:STATUS_DESC
,      MARVIN_CODE
,      SUMMARY_OF_CONDITIONS
,      DECISION
,      ABBREVIATION_TEXT
,      SUBJECT_TEXT
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSFV_UC_CONDITION_DETAILS;

Dependencies

[top of page]

APPS.IGSFV_UC_CONDITION_DETAILS references the following:

APPS: IGS_UC_COND_DETAILS; IGS_UC_OFFER_CONDS; IGS_UC_REF_CODES; IGS_UC_REF_OFF_ABRV

APPS.IGSFV_UC_CONDITION_DETAILS is not referenced by any database object