DBA Data[Home] [Help] [Dependency Information]

TABLE: IGF.IGF_SL_GUARANTOR

Object Details
Object Name: IGF_SL_GUARANTOR
Object Type: TABLE
Owner: IGF
FND Design Data: TableIGF.IGF_SL_GUARANTOR
Subobject Name:
Status: VALID


IGF_SL_GUARANTOR contains the guarantor's detail who guarantees the lender's loan.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGF_SL_GUARANTOR_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnGUARANTOR_ID
IGF_SL_GUARANTOR_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPARTY_ID
Columns
Name Datatype Length Mandatory Comments
GUARANTOR_ID VARCHAR2 (30) Yes Indicates 3-digit code used to identify guarantor associated with loans
DESCRIPTION VARCHAR2 (80) Yes Indicates guarantor's name or description
DUNS_GUARNT_ID VARCHAR2 (30)
Obsolete
PARTY_ID NUMBER (15)
Links guarantor organization with TCA
ENABLED VARCHAR2 (1) Yes Indicator that specifies whether guarantor is active. Setting check box to inactive prevents use of guarantor 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
Query Text

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


SELECT GUARANTOR_ID
,      DESCRIPTION
,      DUNS_GUARNT_ID
,      PARTY_ID
,      ENABLED
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM IGF.IGF_SL_GUARANTOR;

Dependencies

[top of page]

IGF.IGF_SL_GUARANTOR does not reference any database object

IGF.IGF_SL_GUARANTOR is referenced by following:

SchemaAPPS
SynonymIGF_SL_GUARANTOR