[Home] [Help] [Dependency Information]
Object Name: | GMS_IMPLEMENTATIONS_ALL |
---|---|
Object Type: | TABLE |
Owner: | GMS |
FND Design Data: | GMS.GMS_IMPLEMENTATIONS_ALL |
Subobject Name: | |
Status: | VALID |
GMS_IMPLEMENTATIONS_ALL stores the user-defined award numbering method, the manual award numbering type, and the next available sequence-generated award number for setting up award implementation options.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
GMS_IMPLEMENTATIONS_U1 | NORMAL | UNIQUE | APPS_TS_SEED | ORG_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
USER_DEFINED_AWARD_NUM_CODE | VARCHAR2 | (25) | Yes | Identifier that stores whether the award numbering is manual or automatic |
MANUAL_AWARD_NUM_TYPE | VARCHAR2 | (25) | Identifier that stores whether the manual award numbering type is numeric or alphanumeric | |
NEXT_AUTOMATIC_AWARD_NUMBER | NUMBER | (15) | Next available automatic award number from designated sequence | |
AWARD_DISTRIBUTION_OPTION | VARCHAR2 | (1) | Yes | Indicates implementation-specific distribution option for transactions . Transactions can be distributed to one award or many awards. |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Yes | Standard Who column |
CREATION_DATE | DATE | Yes | Standard Who column | |
ENABLED | VARCHAR2 | (1) | Yes | Flag used for enabling and disabling Grants Accounting extensions on all the modules for which Grants is integrated |
ORG_ID | NUMBER | (15) | Operating unit identifier for a multiple organization | |
DEFAULT_DIST_AWARD_NUMBER | VARCHAR2 | (15) | Default distribution award number given by the user at the time of implementation | |
DEFAULT_DIST_AWARD_ID | NUMBER | (15) | Default distribution award id defaulted by the system |
Cut, paste (and edit) the following text to query this object:
SELECT USER_DEFINED_AWARD_NUM_CODE
, MANUAL_AWARD_NUM_TYPE
, NEXT_AUTOMATIC_AWARD_NUMBER
, AWARD_DISTRIBUTION_OPTION
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, CREATION_DATE
, ENABLED
, ORG_ID
, DEFAULT_DIST_AWARD_NUMBER
, DEFAULT_DIST_AWARD_ID
FROM GMS.GMS_IMPLEMENTATIONS_ALL;
GMS.GMS_IMPLEMENTATIONS_ALL does not reference any database object
GMS.GMS_IMPLEMENTATIONS_ALL is referenced by following:
|
|
|