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_RESP_DTLS_V

Object Details

Object Name:	IGF_SL_RESP_DTLS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGF.IGF_SL_RESP_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	Comments
DOCUMENT_ID_TXT	VARCHAR2	(30)	Indicates the document ID
DOC_CREATED_DATE	DATE		Indicates the date and time when the document was created
SOURCE_ENTITY_ID_TXT	VARCHAR2	(30)	Indicates the source Entity ID
DEST_ENTITY_ID_TXT	VARCHAR2	(30)	Indicates the destination Entity ID
SOFT_PROVIDER	VARCHAR2	(30)	Indicates the Software Provider
SOFT_VERSION	VARCHAR2	(30)	Indicates the Software Version
FULL_RESP_CODE	VARCHAR2	(30)	Indicates the full response code of the document
RECEIPT_DATE	DATE		Indicates the date and time stamp that indicates the receipt of the document
DOC_TYPE_CODE	VARCHAR2	(30)	Indicates the code corresponding to the type of data being returned in the document.
DOC_STATUS_CODE	VARCHAR2	(30)	Indicates the status of the processed document on COD.
PROCESS_DATE	DATE		Indicates the date the document information was processed at COD.
REP_SCHL_RESP_ID	NUMBER		Indicates the reporting school response ID
REP_ENTITY_ID_TXT	VARCHAR2	(30)	Indicates the reporting entity ID
RS_RESP_CODE	VARCHAR2	(30)	Indicates the reporting tag response code
ATD_SCHL_RESP_ID	NUMBER		Indicates the attending school response ID
ATD_ENTITY_ID_TXT	VARCHAR2	(30)	Indicates the attending entity ID
AS_RESP_CODE	VARCHAR2	(30)	Indicates the Attending School Response Code
STDNT_RESP_ID	NUMBER		Indicates the student response ID
S_SSN	VARCHAR2	(30)	Indicates the student SSN
FIRST_NAME	VARCHAR2	(60)	Indicates the student first Name
S_LAST_NAME	VARCHAR2	(60)	Indicates the student last Name
S_DATE_OF_BIRTH	DATE		Indicates the student birth date
ST_RESP_CODE	VARCHAR2	(30)	Indicates the student response code
DL_INFO_ID	NUMBER		Indicates the Direct Loan Info ID
LOAN_KEY_NUM	NUMBER		Indicates the Direct Loan Key
ORIG_FEE_PCT_NUM	NUMBER		Indicates the Origination Fee Percent
INT_REB_PCT_NUM	NUMBER		Indicates the interest rebate percent
PNOTE_PRINT_CODE	VARCHAR2	(30)	Indicates the Promissory Note Print Code
DISCLOSURE_PRINT_CODE	VARCHAR2	(30)	Indicates the Disclosure Print Code
GRADE_LEVEL_CODE	VARCHAR2	(30)	Indicates the student's grade level code
DL_LOAN_RESP_ID	NUMBER		Indicates the Direct Loan Response ID
DL_LOAN_TYPE	VARCHAR2	(30)	Indicates the Direct Loan Type
FIN_AWD_YR	VARCHAR2	(30)	Indicates the financial award year
CPS_TRANS_NUM	NUMBER		Indicates the CPS Transaction Number
AWARD_AMT	NUMBER		Indicates the award amount
DEPNCY_STATUS	VARCHAR2	(30)	Indicates the dependency status
DEFAULT_STATUS	VARCHAR2	(30)	Indicates the student default status
AWARD_NUM	NUMBER		Indicates the award number
LOAN_NUMBER	VARCHAR2	(30)	Indicates the Direct Loan Number
AWARD_CREATE_DATE	DATE		Indicates the award creation date
DL_RESP_CODE	VARCHAR2	(30)	Indicates the Direct Loan Response Code
B_RESP_CODE	VARCHAR2	(30)	Indicates the borrower response code
ELEC_MPN_FLAG	VARCHAR2	(30)	Indicates the Electronic MPN Indicator
PNOTE_MPN_ID	VARCHAR2	(30)	Indicates the Promissory Note ID
MPN_STATUS_CODE	VARCHAR2	(30)	Indicates the Promissory Note Status
MPN_LINK_FLAG	VARCHAR2	(30)	Indicates the Promissory Note Link Flag
PYMT_SERVICER_AMT	NUMBER		Indicates the payment servicer amount
PYMT_SERVICER_DATE	DATE		Indicates the payment servicer date
BOOK_LOAN_AMT	NUMBER		Indicates the Booked Loan amount
BOOK_LOAN_AMT_DATE	DATE		Indicates the Booked Loan amount date
ENDORSER_AMT	NUMBER		Indicates the endorser amount
CRDT_DECISION_STATUS	VARCHAR2	(30)	Indicates the credit decision status
CRDT_DECISION_DATE	DATE		Indicates the credit decision date
CRDT_DECISION_OVRD_CODE	VARCHAR2	(30)	Indicates the credit decision override code
CREATED_BY	NUMBER	(15)	Standard Who Column
CREATION_DATE	DATE		Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)	Standard Who Column
LAST_UPDATE_DATE	DATE		Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)	Standard Who Column
PROGRAM_APPLICATION_ID	NUMBER	(15)	Standard Who Column
PROGRAM_ID	NUMBER	(15)	Standard Who Column
PROGRAM_UPDATE_DATE	DATE		Standard Who Column
REQUEST_ID	NUMBER	(15)	Standard Who Column

Query Text

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


SELECT DOCUMENT_ID_TXT
,      DOC_CREATED_DATE
,      SOURCE_ENTITY_ID_TXT
,      DEST_ENTITY_ID_TXT
,      SOFT_PROVIDER
,      SOFT_VERSION
,      FULL_RESP_CODE
,      RECEIPT_DATE
,      DOC_TYPE_CODE
,      DOC_STATUS_CODE
,      PROCESS_DATE
,      REP_SCHL_RESP_ID
,      REP_ENTITY_ID_TXT
,      RS_RESP_CODE
,      ATD_SCHL_RESP_ID
,      ATD_ENTITY_ID_TXT
,      AS_RESP_CODE
,      STDNT_RESP_ID
,      S_SSN
,      FIRST_NAME
,      S_LAST_NAME
,      S_DATE_OF_BIRTH
,      ST_RESP_CODE
,      DL_INFO_ID
,      LOAN_KEY_NUM
,      ORIG_FEE_PCT_NUM
,      INT_REB_PCT_NUM
,      PNOTE_PRINT_CODE
,      DISCLOSURE_PRINT_CODE
,      GRADE_LEVEL_CODE
,      DL_LOAN_RESP_ID
,      DL_LOAN_TYPE
,      FIN_AWD_YR
,      CPS_TRANS_NUM
,      AWARD_AMT
,      DEPNCY_STATUS
,      DEFAULT_STATUS
,      AWARD_NUM
,      LOAN_NUMBER
,      AWARD_CREATE_DATE
,      DL_RESP_CODE
,      B_RESP_CODE
,      ELEC_MPN_FLAG
,      PNOTE_MPN_ID
,      MPN_STATUS_CODE
,      MPN_LINK_FLAG
,      PYMT_SERVICER_AMT
,      PYMT_SERVICER_DATE
,      BOOK_LOAN_AMT
,      BOOK_LOAN_AMT_DATE
,      ENDORSER_AMT
,      CRDT_DECISION_STATUS
,      CRDT_DECISION_DATE
,      CRDT_DECISION_OVRD_CODE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
FROM APPS.IGF_SL_RESP_DTLS_V;

Dependencies

[top of page]

APPS.IGF_SL_RESP_DTLS_V references the following:

APPS: IGF_SL_AS_RESP_DTLS; IGF_SL_CR_RESP_DTLS; IGF_SL_DI_RESP_DTLS; IGF_SL_DL_RESP_DTLS; IGF_SL_RS_RESP_DTLS; IGF_SL_ST_RESP_DTLS

APPS.IGF_SL_RESP_DTLS_V is not referenced by any database object