[Home] [Help] [Dependency Information]
Object Name: | GMS_FP_DISTRIBUTIONS |
---|---|
Object Type: | TABLE |
Owner: | GMS |
FND Design Data: | GMS.GMS_FP_DISTRIBUTIONS |
Subobject Name: | |
Status: | VALID |
GMS_FP_DISTRIBUTIONS stores the funding pattern distribution details for each funding pattern. The distribution can be maintained as percentages across different awards for a sponsored project. The information will be used for automatically charging one transaction to different awards.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
GMS_FP_DISTRIBUTIONS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
FUNDING_PATTERN_ID
AWARD_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FUNDING_PATTERN_ID | NUMBER | (15) | Yes | System generated identifier for a funding pattern |
DISTRIBUTION_NUMBER | NUMBER | (15) | Sequence number of the distribution in a funding pattern | |
AWARD_ID | NUMBER | (15) | Yes | Award identifier of the funding pattern distribution |
DISTRIBUTION_VALUE | NUMBER | (7) | Yes | Percentage value of the distribution in the funding pattern |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Yes | Standard Who column |
Cut, paste (and edit) the following text to query this object:
SELECT FUNDING_PATTERN_ID
, DISTRIBUTION_NUMBER
, AWARD_ID
, DISTRIBUTION_VALUE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
FROM GMS.GMS_FP_DISTRIBUTIONS;
GMS.GMS_FP_DISTRIBUTIONS does not reference any database object
GMS.GMS_FP_DISTRIBUTIONS is referenced by following:
|
|
|