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_AS_GRD_SCH_TRANSLATIONS

Object Details

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

View Type

A Business Intelligence System view

Grading Schema Translations

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
GRADING_SCHEMA_CODE	VARCHAR2	(10)	Yes	The code that identifies the 'from' grading schema when performing a grading schema translation
GS_VERSION_NUMBER	NUMBER	(3)	Yes	A system generated number used to identify the version of the 'from' grading schema when performing a translation
GS_DESCRIPTION	VARCHAR2	(60)	Yes	Describes the 'from' grading schema
GRADE	VARCHAR2	(5)	Yes	The 'from' grade when performing a grading schema translation
FULL_GRADE_NAME	VARCHAR2	(60)	Yes	The full name of 'from' grade
TO_GRADING_SCHEMA_CODE	VARCHAR2	(10)	Yes	The code that identifies the 'to' grading schema when performing a grading schema translation
TO_GS_VERSION_NUMBER	NUMBER	(3)	Yes	A system generated number used to identify the version of the 'to' grading schema when performing a translation
TO_GS_DESCRIPTION	VARCHAR2	(60)	Yes	Describes the 'to' grading schema
TO_GRADE	VARCHAR2	(5)	Yes	The 'to' grade when performing a grading schema translation
TO_FULL_GRADE_NAME	VARCHAR2	(60)	Yes	The full name of 'to' grade
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

Query Text

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


SELECT GRADING_SCHEMA_CODE
,      GS_VERSION_NUMBER
,      GS_DESCRIPTION
,      GRADE
,      FULL_GRADE_NAME
,      TO_GRADING_SCHEMA_CODE
,      TO_GS_VERSION_NUMBER
,      TO_GS_DESCRIPTION
,      TO_GRADE
,      TO_FULL_GRADE_NAME
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSFV_AS_GRD_SCH_TRANSLATIONS;

Dependencies

[top of page]

APPS.IGSFV_AS_GRD_SCH_TRANSLATIONS references the following:

APPS: IGS_AS_GRD_SCHEMA; IGS_AS_GRD_SCH_GRADE; IGS_AS_GRD_SCH_TRN_ALL

APPS.IGSFV_AS_GRD_SCH_TRANSLATIONS is not referenced by any database object