Skip to content

DBA Data[Home] [Help] [Dependency Information]

TABLE: GMS.GMS_FP_DISTRIBUTIONS

Object Details
Object Name: GMS_FP_DISTRIBUTIONS
Object Type: TABLE
Owner: GMS
FND Design Data: TableGMS.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.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
GMS_FP_DISTRIBUTIONS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnFUNDING_PATTERN_ID
ColumnAWARD_ID
Columns
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
Query Text

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;

Dependencies

[top of page]

GMS.GMS_FP_DISTRIBUTIONS does not reference any database object

GMS.GMS_FP_DISTRIBUTIONS is referenced by following:

SchemaGMS
ViewGMS_FP_DISTRIBUTIONS#