[Home] [Help] [Dependency Information]
Object Name: | IGF_SL_CL_RESP_R2_DTLS |
---|---|
Object Type: | TABLE |
Owner: | IGF |
FND Design Data: | IGF.IGF_SL_CL_RESP_R2_DTLS |
Subobject Name: | |
Status: | VALID |
CommonLine Response Table holds information from the Response @2 Layouts
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGF_SL_CL_RESP_R2_DTLS_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | CLRESP2_ID |
IGF_SL_CL_RESP_R2_DTLS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | CLRP1_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CLRESP2_ID | NUMBER | Yes | Primary Key of the table, generated from IGF_SL_CL_RESP_R2_DTLS_S | |
CLRP1_ID | NUMBER | Yes | Foreign Key to Response @1 table | |
RECORD_CODE_TXT | VARCHAR2 | (2) | Record Code | |
UNIQ_LAYOUT_VEND_CODE | VARCHAR2 | (4) | A code (maximum of 4 characters) indicating the vendor that owns the unique supplemental fields layout included in this record. | |
UNIQ_LAYOUT_IDENT_CODE | VARCHAR2 | (2) | A 2-character code identifying the unique supplemental fields layout included in this detail record | |
FILLER_TXT | VARCHAR2 | (2400) | An area reserved for information that is unique to certain disbursing agents. If applicable, the disbursing agent will provide schools or Central Disbursing Agents (CDAs) with documentation listing the fields to be included in this area. | |
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 CLRESP2_ID
, CLRP1_ID
, RECORD_CODE_TXT
, UNIQ_LAYOUT_VEND_CODE
, UNIQ_LAYOUT_IDENT_CODE
, FILLER_TXT
, 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_R2_DTLS;
IGF.IGF_SL_CL_RESP_R2_DTLS does not reference any database object
IGF.IGF_SL_CL_RESP_R2_DTLS is referenced by following:
|
|
|