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_APPR_AST_ITM_GRD_SCHS

Object Details

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

View Type

A Business Intelligence System view

Approved Assessment Item Grading Schema

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
UNIT_CODE	VARCHAR2	(10)	Yes	The unit code to which the approved grading schema for an assessment type is attached
UNIT_VERSION_NUMBER	NUMBER	(3)	Yes	The unit version to which the approved grading schema for an assessment type is attached
UNIT_TITLE	VARCHAR2	(90)	Yes	The unit title to which the approved grading schema for an assessment type is attached
ASSESSMENT_TYPE	VARCHAR2	(10)	Yes	The assessment type for the unit having approved grading schemas
ASSESSMENT_TYPE_DESCRIPTION	VARCHAR2	(60)	Yes	The assessment type description for the unit having approved grading schemas
GRADING_SCHEMA_CODE	VARCHAR2	(10)	Yes	Grading schema code for the assessment type
GRADING_SCHEMA_VERSION_NUMBER	NUMBER	(3)	Yes	Grading schema version for the assessment type
GRADING_SCHEMA_DESCRIPTION	VARCHAR2	(60)	Yes	Grading schema description for the assessment type
_LA:DEFAULT_IND	CHAR	(53)		To indicate that the grading schema is to be defaulted for assessment type when assessment types are linked with unit offering
_LA:CLOSED_IND	CHAR	(52)		The approved grading Schema is available for use or not
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 UNIT_CODE
,      UNIT_VERSION_NUMBER
,      UNIT_TITLE
,      ASSESSMENT_TYPE
,      ASSESSMENT_TYPE_DESCRIPTION
,      GRADING_SCHEMA_CODE
,      GRADING_SCHEMA_VERSION_NUMBER
,      GRADING_SCHEMA_DESCRIPTION
,      _LA:DEFAULT_IND
,      _LA:CLOSED_IND
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSFV_AS_APPR_AST_ITM_GRD_SCHS;

Dependencies

[top of page]

APPS.IGSFV_AS_APPR_AST_ITM_GRD_SCHS references the following:

APPS: IGS_AS_APPR_GRD_SCH; IGS_AS_ASSESSMNT_TYP; IGS_AS_GRD_SCHEMA; IGS_PS_UNIT_VER_ALL

APPS.IGSFV_AS_APPR_AST_ITM_GRD_SCHS is not referenced by any database object