[Home] [Help] [Dependency Information]
Object Name: | AMS_APPROVAL_RULES |
---|---|
Object Type: | TABLE |
Owner: | AMS |
FND Design Data: | AMS.AMS_APPROVAL_RULES |
Subobject Name: | |
Status: | VALID |
AMS_APPROVAL_RULES stores information about what kind of approvals are needed when a major activity is changing status in the system. An activity could for example be a campaign, event, deliverable. A change could be that the status for the activity changes from 'new' to 'submit for budget approval'. For every change there could be one to many approvals needed. Some examples of different approvals:
- Approval by the owner of the parent activity (i.e. campaign owner approvs promotion changes)
- Approval by the sign off (i.e. approval needed by the person that can sign off a certain amount of money)
- Approval by HR manager (i.e. approval needed by the direct report manager)
There can be different approvals per activity type.
Tablespace: | APPS_TS_ARCHIVE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AMS_APPROVAL_RULES_U1 | NORMAL | UNIQUE | APPS_TS_ARCHIVE | APPROVAL_RULE_ID |
AMS_APPROVAL_RULES_N2 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE | ARC_APPROVAL_FOR_OBJECT |
AMS_APPROVAL_RULES_N3 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE | ACTIVITY_TYPE_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
APPROVAL_RULE_ID | NUMBER | Yes | Approval rule identifier | |
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) | Standard WHO Column | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | This column is used for locking purposes | |
ARC_APPROVAL_FOR_OBJECT | VARCHAR2 | (30) | Yes | The object type which the approval is for |
APPROVAL_TYPE | VARCHAR2 | (30) | Yes | Approval type |
TIMEOUT_DAYS_LOW_PRIO | NUMBER | (15) | Yes | Timeout days for low priority |
TIMEOUT_DAYS_STD_PRIO | NUMBER | (15) | Yes | Timeout days for standart priority |
TIMEOUT_DAYS_HIGH_PRIO | NUMBER | (15) | Yes | Timeout days for high priority |
TIMEOUT_DAYS_MEDIUM_PRIO | NUMBER | (15) | Yes | Timeout days for medium priority |
MGR_APPROVAL_NEEDED_FLAG | VARCHAR2 | (1) | Yes | Flag to indicate if the approval from manager is needed |
PARENT_OWNER_APPROVAL_FLAG | VARCHAR2 | (1) | Yes | Flag to indicate if the approval from the parent object owner is needed |
ACTIVITY_TYPE_CODE | VARCHAR2 | (30) | Activity type code | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments |
Cut, paste (and edit) the following text to query this object:
SELECT APPROVAL_RULE_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
, ARC_APPROVAL_FOR_OBJECT
, APPROVAL_TYPE
, TIMEOUT_DAYS_LOW_PRIO
, TIMEOUT_DAYS_STD_PRIO
, TIMEOUT_DAYS_HIGH_PRIO
, TIMEOUT_DAYS_MEDIUM_PRIO
, MGR_APPROVAL_NEEDED_FLAG
, PARENT_OWNER_APPROVAL_FLAG
, ACTIVITY_TYPE_CODE
, SECURITY_GROUP_ID
FROM AMS.AMS_APPROVAL_RULES;
AMS.AMS_APPROVAL_RULES does not reference any database object
AMS.AMS_APPROVAL_RULES is referenced by following:
|
|
|