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

Object Details

Object Name:	IGF_SL_CLCHSN_DTLS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGF.IGF_SL_CLCHSN_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
CLCHGSND_ID	NUMBER		Yes	Sequence generated primary key
CL_VERSION_CODE	VARCHAR2	(30)	Yes	CommonLine Loan Version
AWARD_ID	NUMBER		Yes	Award ID
LOAN_NUMBER_TXT	VARCHAR2	(30)	Yes	Loan Number
DISBURSEMENT_NUMBER	NUMBER			Disbursement Number
DISBURSEMENT_DATE	DATE			Disbursement Date
CHANGE_ISSUE_CODE	VARCHAR2	(30)		Change Issued Code
CHANGE_ISSUE_CODE_DESC	VARCHAR2	(4000)		Change Issued Code Description
CHANGE_CODE_TXT	VARCHAR2	(30)	Yes	Change Code
CHANGE_CODE_DESC	VARCHAR2	(2400)		Change Code Description
CHANGE_FIELD_CODE	VARCHAR2	(30)	Yes	Change Field Code
CHANGE_FIELD_CODE_DESC	VARCHAR2	(4000)		Change Field Code Description
CHANGE_RECORD_TYPE_TXT	VARCHAR2	(30)	Yes	Change Record Type
CHANGE_RECORD_TYPE_DESC	VARCHAR2	(2400)		Change Record Type Description
OLD_VALUE_TXT	VARCHAR2	(30)		Old value of the changed field
NEW_VALUE_TXT	VARCHAR2	(30)		New value of the changed field
OLD_AMT	NUMBER			Old value of the changed field of Number Type
NEW_AMT	NUMBER			New value of the changed field of Number Type
OLD_DATE	DATE			Old value of the changed field of Date Type
NEW_DATE	DATE			New value of the changed field of Date Type
DISBURSEMENT_CANCEL_AMT	NUMBER			Disbursement Cancel Amount
DISBURSEMENT_CANCEL_DATE	DATE			Disbursement Cancel Date
DISBURSEMENT_REINST_CODE	VARCHAR2	(30)		Disbursement Re-instatement Code
DISBURSEMENT_REINST_DESC	VARCHAR2	(4000)		Disbursement Re-instatement Description
DISBURSEMENT_REISSUE_CODE	VARCHAR2	(30)		Disbursement Re-issue Code
DISBURSEMENT_REISSUE_DESC	VARCHAR2	(4000)		Disbursement Re-issue Description
DISBURSEMENT_RETURN_AMT	NUMBER	(15)		Disbursement Return Amount
DISBURSEMENT_RETURN_CODE	VARCHAR2	(30)		Disbursement Fund Return Code
DISBURSEMENT_RETURN_DESC	VARCHAR2	(4000)		Disbursement Fund Return Code Description
DISBURSEMENT_RETURN_DATE	DATE			Disbursement Return Date
DISBURSEMENT_REVISED_AMT	NUMBER	(15)		Disbursement Revised Amount
DISBURSEMENT_REVISED_DATE	DATE			Disbursement Revised Date
GUARANTOR_USE_TXT	VARCHAR2	(80)		Guarantor Use Text
LENDER_USE_TXT	VARCHAR2	(80)		Lender Use Text
RESPONSE_STATUS_CODE	VARCHAR2	(30)		Response Status Code
RESPONSE_STATUS_CODE_DESC	VARCHAR2	(4000)		Response Status Code Description
SCHOOL_USE_TXT	VARCHAR2	(80)		School Use Text
SEND_RECORD_TXT	VARCHAR2	(1000)		Send Record
STATUS_CODE	VARCHAR2	(1)	Yes	Internal Change Send Record Status Code
STATUS_CODE_DESC	VARCHAR2	(4000)		Internal Change Send Record Status Code Description
STATUS_DATE	DATE		Yes	Internal Change Send Record Status Date
VALIDATION_EDIT_TXT	VARCHAR2	(4000)		Validation Edit Results
CREATED_BY	NUMBER	(15)	Yes	Standard Who Columns
CREATION_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who Column
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who Column
REQUEST_ID	NUMBER	(15)		Standard Who Column for Concurrent Program
PROGRAM_APPLICATION_ID	NUMBER	(15)		Standard Who Column for Concurrent Program
PROGRAM_ID	NUMBER	(15)		Standard Who Column for Concurrent Program
PROGRAM_UPDATE_DATE	DATE			Standard Who Column for Concurrent Program

Query Text

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


SELECT ROW_ID
,      CLCHGSND_ID
,      CL_VERSION_CODE
,      AWARD_ID
,      LOAN_NUMBER_TXT
,      DISBURSEMENT_NUMBER
,      DISBURSEMENT_DATE
,      CHANGE_ISSUE_CODE
,      CHANGE_ISSUE_CODE_DESC
,      CHANGE_CODE_TXT
,      CHANGE_CODE_DESC
,      CHANGE_FIELD_CODE
,      CHANGE_FIELD_CODE_DESC
,      CHANGE_RECORD_TYPE_TXT
,      CHANGE_RECORD_TYPE_DESC
,      OLD_VALUE_TXT
,      NEW_VALUE_TXT
,      OLD_AMT
,      NEW_AMT
,      OLD_DATE
,      NEW_DATE
,      DISBURSEMENT_CANCEL_AMT
,      DISBURSEMENT_CANCEL_DATE
,      DISBURSEMENT_REINST_CODE
,      DISBURSEMENT_REINST_DESC
,      DISBURSEMENT_REISSUE_CODE
,      DISBURSEMENT_REISSUE_DESC
,      DISBURSEMENT_RETURN_AMT
,      DISBURSEMENT_RETURN_CODE
,      DISBURSEMENT_RETURN_DESC
,      DISBURSEMENT_RETURN_DATE
,      DISBURSEMENT_REVISED_AMT
,      DISBURSEMENT_REVISED_DATE
,      GUARANTOR_USE_TXT
,      LENDER_USE_TXT
,      RESPONSE_STATUS_CODE
,      RESPONSE_STATUS_CODE_DESC
,      SCHOOL_USE_TXT
,      SEND_RECORD_TXT
,      STATUS_CODE
,      STATUS_CODE_DESC
,      STATUS_DATE
,      VALIDATION_EDIT_TXT
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM APPS.IGF_SL_CLCHSN_DTLS_V;

Dependencies

[top of page]

APPS.IGF_SL_CLCHSN_DTLS_V references the following:

APPS: IGF_AW_GEN - show dependent code; IGF_SL_CLCHSN_DTLS; IGF_SL_CL_CHG_REC_TYPES

APPS.IGF_SL_CLCHSN_DTLS_V is not referenced by any database object