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_RECIPIENT

Object Details

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

IGF_SL_CL_RECIPIENT maintains the relationships between the lenders, guarantors, and recipients.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGF_SL_CL_RECIPIENT_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	RCPT_ID
IGF_SL_CL_RECIPIENT_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	LENDER_ID LEND_NON_ED_BRC_ID GUARANTOR_ID RECIPIENT_ID RECIP_NON_ED_BRC_ID RELATIONSHIP_CD
IGF_SL_CL_RECIPIENT_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	RELATIONSHIP_CD

Columns

Name	Datatype	Length	Mandatory	Comments
RCPT_ID	NUMBER	(15)	Yes	Identifier for recipient
LENDER_ID	VARCHAR2	(30)	Yes	Identifier for lender
LEND_NON_ED_BRC_ID	VARCHAR2	(30)		Indicates non-ED branch for particular lender
GUARANTOR_ID	VARCHAR2	(30)	Yes	Identifier for guarantor
RECIPIENT_ID	VARCHAR2	(30)	Yes	Indicates either lender, guarantor, or servicer identifier
RECIPIENT_TYPE	VARCHAR2	(30)	Yes	Indicates lender, guarantor, or servicer
RECIP_NON_ED_BRC_ID	VARCHAR2	(30)		Indicates non-ED branch of lender or servicer selected as recipient
ENABLED	VARCHAR2	(1)	Yes	Indicator that specifies whether recipient is active. Setting check box to inactive prevents use of recipient in new or modified records.
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
RELATIONSHIP_CD	VARCHAR2	(30)		Relationship code
RELATIONSHIP_CD_DESC	VARCHAR2	(80)		Relationship code description
PREFERRED_FLAG	VARCHAR2	(1)		Indicates that whether the recipient is chosen as preferred.

Query Text

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


SELECT RCPT_ID
,      LENDER_ID
,      LEND_NON_ED_BRC_ID
,      GUARANTOR_ID
,      RECIPIENT_ID
,      RECIPIENT_TYPE
,      RECIP_NON_ED_BRC_ID
,      ENABLED
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      RELATIONSHIP_CD
,      RELATIONSHIP_CD_DESC
,      PREFERRED_FLAG
FROM IGF.IGF_SL_CL_RECIPIENT;

Dependencies

[top of page]

IGF.IGF_SL_CL_RECIPIENT does not reference any database object

IGF.IGF_SL_CL_RECIPIENT is referenced by following:

APPS: IGF_SL_CL_RECIPIENT