[Home] [Help] [Dependency Information]
Object Name: | IGF_SL_CLCHSN_DTLS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGF.IGF_SL_CLCHSN_DTLS_V |
Subobject Name: | |
Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Row ID | |
CLCHGSND_ID | NUMBER | Yes | Sequence generated primary key | |
CL_VERSION_CODE | VARCHAR2 | (30) | Yes | CommonLine Loan Version |
AWARD_ID | NUMBER | Yes | Award ID | |
LOAN_NUMBER_TXT | VARCHAR2 | (30) | Yes | Loan Number |
DISBURSEMENT_NUMBER | NUMBER | Disbursement Number | ||
DISBURSEMENT_DATE | DATE | Disbursement Date | ||
CHANGE_ISSUE_CODE | VARCHAR2 | (30) | Change Issued Code | |
CHANGE_ISSUE_CODE_DESC | VARCHAR2 | (4000) | Change Issued Code Description | |
CHANGE_CODE_TXT | VARCHAR2 | (30) | Yes | Change Code |
CHANGE_CODE_DESC | VARCHAR2 | (2400) | Change Code Description | |
CHANGE_FIELD_CODE | VARCHAR2 | (30) | Yes | Change Field Code |
CHANGE_FIELD_CODE_DESC | VARCHAR2 | (4000) | Change Field Code Description | |
CHANGE_RECORD_TYPE_TXT | VARCHAR2 | (30) | Yes | Change Record Type |
CHANGE_RECORD_TYPE_DESC | VARCHAR2 | (2400) | Change Record Type Description | |
OLD_VALUE_TXT | VARCHAR2 | (30) | Old value of the changed field | |
NEW_VALUE_TXT | VARCHAR2 | (30) | New value of the changed field | |
OLD_AMT | NUMBER | Old value of the changed field of Number Type | ||
NEW_AMT | NUMBER | New value of the changed field of Number Type | ||
OLD_DATE | DATE | Old value of the changed field of Date Type | ||
NEW_DATE | DATE | New value of the changed field of Date Type | ||
DISBURSEMENT_CANCEL_AMT | NUMBER | Disbursement Cancel Amount | ||
DISBURSEMENT_CANCEL_DATE | DATE | Disbursement Cancel Date | ||
DISBURSEMENT_REINST_CODE | VARCHAR2 | (30) | Disbursement Re-instatement Code | |
DISBURSEMENT_REINST_DESC | VARCHAR2 | (4000) | Disbursement Re-instatement Description | |
DISBURSEMENT_REISSUE_CODE | VARCHAR2 | (30) | Disbursement Re-issue Code | |
DISBURSEMENT_REISSUE_DESC | VARCHAR2 | (4000) | Disbursement Re-issue Description | |
DISBURSEMENT_RETURN_AMT | NUMBER | (15) | Disbursement Return Amount | |
DISBURSEMENT_RETURN_CODE | VARCHAR2 | (30) | Disbursement Fund Return Code | |
DISBURSEMENT_RETURN_DESC | VARCHAR2 | (4000) | Disbursement Fund Return Code Description | |
DISBURSEMENT_RETURN_DATE | DATE | Disbursement Return Date | ||
DISBURSEMENT_REVISED_AMT | NUMBER | (15) | Disbursement Revised Amount | |
DISBURSEMENT_REVISED_DATE | DATE | Disbursement Revised Date | ||
GUARANTOR_USE_TXT | VARCHAR2 | (80) | Guarantor Use Text | |
LENDER_USE_TXT | VARCHAR2 | (80) | Lender Use Text | |
RESPONSE_STATUS_CODE | VARCHAR2 | (30) | Response Status Code | |
RESPONSE_STATUS_CODE_DESC | VARCHAR2 | (4000) | Response Status Code Description | |
SCHOOL_USE_TXT | VARCHAR2 | (80) | School Use Text | |
SEND_RECORD_TXT | VARCHAR2 | (1000) | Send Record | |
STATUS_CODE | VARCHAR2 | (1) | Yes | Internal Change Send Record Status Code |
STATUS_CODE_DESC | VARCHAR2 | (4000) | Internal Change Send Record Status Code Description | |
STATUS_DATE | DATE | Yes | Internal Change Send Record Status Date | |
VALIDATION_EDIT_TXT | VARCHAR2 | (4000) | Validation Edit Results | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who Columns |
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 ROW_ID
, CLCHGSND_ID
, CL_VERSION_CODE
, AWARD_ID
, LOAN_NUMBER_TXT
, DISBURSEMENT_NUMBER
, DISBURSEMENT_DATE
, CHANGE_ISSUE_CODE
, CHANGE_ISSUE_CODE_DESC
, CHANGE_CODE_TXT
, CHANGE_CODE_DESC
, CHANGE_FIELD_CODE
, CHANGE_FIELD_CODE_DESC
, CHANGE_RECORD_TYPE_TXT
, CHANGE_RECORD_TYPE_DESC
, OLD_VALUE_TXT
, NEW_VALUE_TXT
, OLD_AMT
, NEW_AMT
, OLD_DATE
, NEW_DATE
, DISBURSEMENT_CANCEL_AMT
, DISBURSEMENT_CANCEL_DATE
, DISBURSEMENT_REINST_CODE
, DISBURSEMENT_REINST_DESC
, DISBURSEMENT_REISSUE_CODE
, DISBURSEMENT_REISSUE_DESC
, DISBURSEMENT_RETURN_AMT
, DISBURSEMENT_RETURN_CODE
, DISBURSEMENT_RETURN_DESC
, DISBURSEMENT_RETURN_DATE
, DISBURSEMENT_REVISED_AMT
, DISBURSEMENT_REVISED_DATE
, GUARANTOR_USE_TXT
, LENDER_USE_TXT
, RESPONSE_STATUS_CODE
, RESPONSE_STATUS_CODE_DESC
, SCHOOL_USE_TXT
, SEND_RECORD_TXT
, STATUS_CODE
, STATUS_CODE_DESC
, STATUS_DATE
, VALIDATION_EDIT_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 APPS.IGF_SL_CLCHSN_DTLS_V;
APPS.IGF_SL_CLCHSN_DTLS_V is not referenced by any database object
|
|
|