[Home] [Help] [Dependency Information]
Object Name: | IGF_SL_CL_RESP_R3_DTLS |
---|---|
Object Type: | TABLE |
Owner: | IGF |
FND Design Data: | IGF.IGF_SL_CL_RESP_R3_DTLS |
Subobject Name: | |
Status: | VALID |
CommonLine Response Table holds information from the Response @3 Layouts
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGF_SL_CL_RESP_R3_DTLS_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | CLRESP3_ID |
IGF_SL_CL_RESP_R3_DTLS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | CLRP1_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CLRESP3_ID | NUMBER | Yes | Primary Key of the table, generated from IGF_SL_CL_RESP_R3_DTLS_S | |
CLRP1_ID | NUMBER | Yes | Foreign Key to Response @1 table | |
RECORD_CODE_TXT | VARCHAR2 | (2) | Record Code | |
MESSAGE_1_TEXT | VARCHAR2 | (240) | A brief description of the first message for the loan or application | |
MESSAGE_2_TEXT | VARCHAR2 | (240) | A brief description of the second message for the loan or application | |
MESSAGE_3_TEXT | VARCHAR2 | (240) | A brief description of the third message for the loan or application | |
MESSAGE_4_TEXT | VARCHAR2 | (240) | A brief description of the fourth message for the loan or application | |
MESSAGE_5_TEXT | VARCHAR2 | (240) | A brief description of the fifth message for the loan or application | |
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 Program | |
PROGRAM_APPLICATION_ID | NUMBER | (15) | Standard Who column for Concurrent Program | |
PROGRAM_ID | NUMBER | (15) | Standard Who column for Concurrent Program | |
PROGRAM_UPDATE_DATE | DATE | Standard Who column for Concurrent Program |
Cut, paste (and edit) the following text to query this object:
SELECT CLRESP3_ID
, CLRP1_ID
, RECORD_CODE_TXT
, MESSAGE_1_TEXT
, MESSAGE_2_TEXT
, MESSAGE_3_TEXT
, MESSAGE_4_TEXT
, MESSAGE_5_TEXT
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
FROM IGF.IGF_SL_CL_RESP_R3_DTLS;
IGF.IGF_SL_CL_RESP_R3_DTLS does not reference any database object
IGF.IGF_SL_CL_RESP_R3_DTLS is referenced by following:
|
|
|