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_CL_RESP_R8

Object Details

Object Name:	IGF_SL_CL_RESP_R8
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGF.IGF_SL_CL_RESP_R8
Subobject Name:
Status:	VALID

View Type

A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)
CLRP1_ID	NUMBER	(15)	Yes
CLRP8_ID	NUMBER	(15)	Yes
DISB_DATE	DATE
DISB_GROSS_AMT	NUMBER	(12)
ORIG_FEE	NUMBER	(12)
GUARANTEE_FEE	NUMBER	(12)
NET_DISB_AMT	NUMBER	(12)
DISB_HOLD_REL_IND	VARCHAR2	(30)
DISB_STATUS	VARCHAR2	(30)
GUARNT_FEE_PAID	NUMBER	(12)
ORIG_FEE_PAID	NUMBER	(12)
RESP_RECORD_STATUS	VARCHAR2	(30)
CREATED_BY	NUMBER	(15)	Yes
CREATION_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATE_LOGIN	NUMBER	(15)
REQUEST_ID	NUMBER	(15)
PROGRAM_APPLICATION_ID	NUMBER	(15)
PROGRAM_ID	NUMBER	(15)
PROGRAM_UPDATE_DATE	DATE
ORG_ID	NUMBER	(15)
LAYOUT_OWNER_CODE_TXT	VARCHAR2	(4)		Supplemental Disbursement Layout Owner Code, this field would always have NCLP as the Layout is owned by NCHELP. This field is not applicable for CommonLine Release 4 Version Loans
LAYOUT_VERSION_CODE_TXT	VARCHAR2	(2)		A 2-character code identifying the field layout included in this record. This field must contain the constant: 05 for Release 5. This field is not applicable for CommonLine Release 4 Version Loans
RECORD_CODE_TXT	VARCHAR2	(30)		Record Code
DIRECT_TO_BORR_FLAG	VARCHAR2	(1)		Direct Disbursement to Borrower Indicator

Query Text

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


SELECT ROW_ID
,      CLRP1_ID
,      CLRP8_ID
,      DISB_DATE
,      DISB_GROSS_AMT
,      ORIG_FEE
,      GUARANTEE_FEE
,      NET_DISB_AMT
,      DISB_HOLD_REL_IND
,      DISB_STATUS
,      GUARNT_FEE_PAID
,      ORIG_FEE_PAID
,      RESP_RECORD_STATUS
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ORG_ID
,      LAYOUT_OWNER_CODE_TXT
,      LAYOUT_VERSION_CODE_TXT
,      RECORD_CODE_TXT
,      DIRECT_TO_BORR_FLAG
FROM APPS.IGF_SL_CL_RESP_R8;

Dependencies

[top of page]

APPS.IGF_SL_CL_RESP_R8 references the following:

APPS: IGF_SL_CL_RESP_R8_ALL

APPS.IGF_SL_CL_RESP_R8 is referenced by following:

APPS: IGF_SL_CL_ORIG_ACK - show dependent code