[Home] [Help] [Dependency Information]
Object Name: | IGF_AW_AWARD_LEVEL_HIST_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGF.IGF_AW_AWARD_LEVEL_HIST_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) | Oracle ID | |
AWARD_ID | NUMBER | Yes | Award ID of the award for which the change is being made. | |
AWARD_HIST_TRAN_ID | NUMBER | Yes | Identifies the Transactionwhich is causing the Award update. | |
AWARD_ATTRIB_CODE | VARCHAR2 | (30) | Yes | Lookup Quick Code Code |
AWARD_CHANGE_SOURCE_CODE | VARCHAR2 | (30) | Yes | Lookup Code Award Change Source |
OLD_OFFERED_AMT | NUMBER | Old Offered Amount | ||
NEW_OFFERED_AMT | NUMBER | New Offered Amount | ||
OLD_ACCEPTED_AMT | NUMBER | Old Accepted Amount | ||
NEW_ACCEPTED_AMT | NUMBER | New Accepted Amount | ||
OLD_PAID_AMT | NUMBER | Old Paid Amount | ||
NEW_PAID_AMT | NUMBER | New Paid Amount | ||
OLD_LOCK_AWARD_FLAG | VARCHAR2 | (1) | Old Lock Status | |
NEW_LOCK_AWARD_FLAG | VARCHAR2 | (1) | New Lock Status | |
OLD_AWARD_STATUS_CODE | VARCHAR2 | (30) | Old Award Status | |
NEW_AWARD_STATUS_CODE | VARCHAR2 | (30) | New Award Status | |
OLD_ADPLANS_ID | NUMBER | Old Foreign Key to the Award Distribution Plan Table | ||
NEW_ADPLANS_ID | NUMBER | New Foreign Key to the Award Distribution Plan Table | ||
AWARD_ATTRIBUTE_DESC | VARCHAR2 | (4000) | Award Attribute Description | |
AWARD_CHANGE_SOURCE_DESC | VARCHAR2 | (4000) | Award Change Source Description | |
DERIVED_AWARD_UPDATE_DATE | DATE | Derived Award Update Date | ||
OLD_VALUE | VARCHAR2 | (4000) | Old Data Value | |
NEW_VALUE | VARCHAR2 | (4000) | New Data Value | |
USER_NAME | VARCHAR2 | (100) | Yes | FND User Name |
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 | Standard Concurrent Who Column | ||
PROGRAM_APPLICATION_ID | NUMBER | Standard Concurrent Who Column | ||
PROGRAM_ID | NUMBER | Standard Concurrent Who Column | ||
PROGRAM_UPDATE_DATE | DATE | Standard Concurrent Who Column |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, AWARD_ID
, AWARD_HIST_TRAN_ID
, AWARD_ATTRIB_CODE
, AWARD_CHANGE_SOURCE_CODE
, OLD_OFFERED_AMT
, NEW_OFFERED_AMT
, OLD_ACCEPTED_AMT
, NEW_ACCEPTED_AMT
, OLD_PAID_AMT
, NEW_PAID_AMT
, OLD_LOCK_AWARD_FLAG
, NEW_LOCK_AWARD_FLAG
, OLD_AWARD_STATUS_CODE
, NEW_AWARD_STATUS_CODE
, OLD_ADPLANS_ID
, NEW_ADPLANS_ID
, AWARD_ATTRIBUTE_DESC
, AWARD_CHANGE_SOURCE_DESC
, DERIVED_AWARD_UPDATE_DATE
, OLD_VALUE
, NEW_VALUE
, USER_NAME
, 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_AW_AWARD_LEVEL_HIST_V;
APPS.IGF_AW_AWARD_LEVEL_HIST_V is not referenced by any database object
|
|
|