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_HE_EX_RN_FD_LN_DTLS_V

Object Details

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

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Row ID
RN_DAT_FD_ID	NUMBER		Yes	Sequence generated column used to uniquely identify the Extract run data fields
EXTRACT_RUN_ID	NUMBER		Yes	Sequence generated column used to uniquely identify the extract process
FIELD_NUMBER	NUMBER		Yes	Indicates the Field Number after extraction process
LINE_NUMBER	NUMBER		Yes	Indicates the Line Number after the extraction process
PERSON_ID	NUMBER			Contains the person id for which the extraction process was done and is used for updating the Student Program Attempt Records
STUDENT_INST_NUMBER	VARCHAR2	(20)		Student Instance Number
COURSE_CD	VARCHAR2	(6)		Indicates the Course code of the person for which this line is being generated and used to update the Student Program Attempt Records
CRV_VERSION_NUMBER	NUMBER	(3)		Course Version Number
UNIT_CD	VARCHAR2	(10)		Unit Code
UV_VERSION_NUMBER	NUMBER	(3)		Unit Version Number
VALUE	VARCHAR2	(100)		Holds the Value of the extracted field
OVERRIDE_VALUE	VARCHAR2	(100)		Contains the overridden value, if the value is overridden after extraction process is complete
MANUALLY_INSERTED	VARCHAR2	(3)	Yes	Indicates whether the line has been manually inserted. Default value will be NO
EXCLUDE_FROM_FILE	VARCHAR2	(3)	Yes	Indicates whether this line should be excluded from the physical file. Default value will be NO
RECALCULATE_FLAG	VARCHAR2	(1)	Yes	Recalculate Flag, Valid values 'Y', 'N'

Query Text

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


SELECT ROW_ID
,      RN_DAT_FD_ID
,      EXTRACT_RUN_ID
,      FIELD_NUMBER
,      LINE_NUMBER
,      PERSON_ID
,      STUDENT_INST_NUMBER
,      COURSE_CD
,      CRV_VERSION_NUMBER
,      UNIT_CD
,      UV_VERSION_NUMBER
,      VALUE
,      OVERRIDE_VALUE
,      MANUALLY_INSERTED
,      EXCLUDE_FROM_FILE
,      RECALCULATE_FLAG
FROM APPS.IGS_HE_EX_RN_FD_LN_DTLS_V;

Dependencies

[top of page]

APPS.IGS_HE_EX_RN_FD_LN_DTLS_V references the following:

APPS: IGS_HE_EX_RN_DAT_FD; IGS_HE_EX_RN_DAT_LN

APPS.IGS_HE_EX_RN_FD_LN_DTLS_V is not referenced by any database object