[Home] [Help]
[Dependency Information]
Object Name: | GMS_BUDGETARY_CONTROLS |
---|---|
Object Type: | TABLE |
Owner: | GMS |
FND Design Data: | ![]() |
Subobject Name: | |
Status: | VALID |
GMS_BUDGETARY_CONTROLS stores budgetary control levels for an award project. Budgetary control levels are Absolute, Advisory, or None.
Tablespace: | ![]() |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
GMS_BUDGETARY_CONTROLS_U1 | NORMAL | UNIQUE |
![]() |
![]() |
GMS_BUDGETARY_CONTROLS_U2 | NORMAL | UNIQUE |
![]() |
![]() ![]() ![]() ![]() |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BUDGETARY_CONTROLS_ID | NUMBER | (15) | Yes | Budgetary control defining column |
PROJECT_ID | NUMBER | (15) | Yes | Project defining column |
FUNDS_CONTROL_LEVEL_CODE | VARCHAR2 | (1) | Yes | Funds control level codes for funds checking. D indicates Advisory, B indicates Absolute, and N indicates None. |
AWARD_ID | NUMBER | (15) | Yes | Award defining column |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
CREATION_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Yes | Standard Who column |
TOP_TASK_ID | NUMBER | (15) | Not currently used | |
TASK_ID | NUMBER | (15) | Task defining column | |
PARENT_MEMBER_ID | NUMBER | (15) | Parent member defining column | |
RESOURCE_LIST_MEMBER_ID | NUMBER | (15) | Resource list defining column |
Cut, paste (and edit) the following text to query this object:
SELECT BUDGETARY_CONTROLS_ID
, PROJECT_ID
, FUNDS_CONTROL_LEVEL_CODE
, AWARD_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_LOGIN
, TOP_TASK_ID
, TASK_ID
, PARENT_MEMBER_ID
, RESOURCE_LIST_MEMBER_ID
FROM GMS.GMS_BUDGETARY_CONTROLS;
GMS.GMS_BUDGETARY_CONTROLS does not reference any database object
GMS.GMS_BUDGETARY_CONTROLS is referenced by following:
|
|
|