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]

TABLE: IGF.IGF_SL_CL_RESP_R8_ALL

Object Details

Object Name:	IGF_SL_CL_RESP_R8_ALL
Object Type:	TABLE
Owner:	IGF
FND Design Data:	IGF.IGF_SL_CL_RESP_R8_ALL
Subobject Name:
Status:	VALID

IGF_SL_CL_RESP_R8_ALL maintains the CommonLine response @8 records from the external processor inserted or updated only by the CommonLine response load process.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGF_SL_CL_RESP_R8_ALL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	CLRP1_ID CLRP8_ID

Columns

Name	Datatype	Length	Mandatory	Comments
CLRP1_ID	NUMBER	(15)	Yes	Identifier for CommonLine response @1 records from external processor
CLRP8_ID	NUMBER	(15)	Yes	Identifier for CommonLine response @8 records from external processor
DISB_DATE	DATE			Indicates disbursement date
DISB_GROSS_AMT	NUMBER	(12)		Indicates disbursement gross amount
ORIG_FEE	NUMBER	(12)		Indicates origination fee
GUARANTEE_FEE	NUMBER	(12)		Indicates guarantee fee
NET_DISB_AMT	NUMBER	(12)		Indicates net disbursement amount
DISB_HOLD_REL_IND	VARCHAR2	(30)		Indicates disbursement hold or release indicator
DISB_STATUS	VARCHAR2	(30)		Indicates disbursement status
GUARNT_FEE_PAID	NUMBER	(12)		Indicates guarantee fee paid
ORIG_FEE_PAID	NUMBER	(12)		Indicates origination fee paid
RESP_RECORD_STATUS	VARCHAR2	(30)		Keeps track of all records processed and successfully updated
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
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
REQUEST_ID	NUMBER	(15)		Standard Who column for concurrent programs
PROGRAM_APPLICATION_ID	NUMBER	(15)		Standard Who column for concurrent programs
PROGRAM_ID	NUMBER	(15)		Standard Who column for concurrent programs
PROGRAM_UPDATE_DATE	DATE			Standard Who column for concurrent programs
ORG_ID	NUMBER	(15)		Operating unit identifier
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 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 IGF.IGF_SL_CL_RESP_R8_ALL;

Dependencies

[top of page]

IGF.IGF_SL_CL_RESP_R8_ALL does not reference any database object

IGF.IGF_SL_CL_RESP_R8_ALL is referenced by following:

APPS: IGF_SL_CL_RESP_R8_ALL