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

TABLE: IGF.IGF_SL_LI_CHG_INTS

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


Stores Direct Loan Change Send Response Interface Data
Scope: public
Product: IGF
Lifecycle: active
Display Name: Legacy - Direct Loan Origination and Disbursement Data Import Process
Category: BUSINESS_ENTITY IGF_DL


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGF_SL_LI_CHG_INTS_PK NORMAL UNIQUE TablespaceAPPS_TS_INTERFACE ColumnLOAN_NUMBER_TXT
ColumnCHANGE_CODE
Columns
Name Datatype Length Mandatory Comments
LOAN_NUMBER_TXT VARCHAR2 (21) Yes Indicates Loan Number
CHANGE_CODE VARCHAR2 (30) Yes Indicates Change code
SEND_BATCH_ID_TXT VARCHAR2 (23) Yes Indicates change batch identifier from change record in the Send file
RESP_BATCH_ID_TXT VARCHAR2 (23)
Indicates change batch identifier from change record in the Response file
REJECT_CODE VARCHAR2 (30)
Indicates reject code
NEW_VALUE_TXT VARCHAR2 (50)
Indicates new value for field in change file
LOAN_IDENT_ERR_CODE VARCHAR2 (30)
Indicates error code for loan
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
Query Text

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


SELECT LOAN_NUMBER_TXT
,      CHANGE_CODE
,      SEND_BATCH_ID_TXT
,      RESP_BATCH_ID_TXT
,      REJECT_CODE
,      NEW_VALUE_TXT
,      LOAN_IDENT_ERR_CODE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM IGF.IGF_SL_LI_CHG_INTS;

Dependencies

[top of page]

IGF.IGF_SL_LI_CHG_INTS does not reference any database object

IGF.IGF_SL_LI_CHG_INTS is referenced by following:

SchemaAPPS
SynonymIGF_SL_LI_CHG_INTS