[Home] [Help] [Dependency Information]
Object Name: | AMS_STATUS_ORDER_RULES |
---|---|
Object Type: | TABLE |
Owner: | AMS |
FND Design Data: | AMS.AMS_STATUS_ORDER_RULES |
Subobject Name: | |
Status: | VALID |
AMS_STATUS_ORDER_RULES stores what are the allowed changes that can be done of status. This entity checks the status changes that are allowed (i.e. what status is allowable to go to from previous status). Some of the statuses are not available to the end user and can only be set by the system. This table is used by all tables in Oracle Marketing for status rules.
Some examples could be:
From To
------- ---
New Submmit for Theme Approval
Submit for Theme Approval Planned
Submit for Theme Approval New
Planned Active
Planned Cancelled
Active Archived
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AMS_STATUS_ORDER_RULES_U1 | NORMAL | UNIQUE | APPS_TS_SEED | STATUS_ORDER_RULE_ID |
AMS_STATUS_ORDER_RULES_U2 | NORMAL | UNIQUE | APPS_TS_SEED |
CURRENT_STATUS_CODE
SYSTEM_STATUS_TYPE NEXT_STATUS_CODE |
AMS_STATUS_ORDER_RULES_N1 | NORMAL | NONUNIQUE | APPS_TS_SEED | SYSTEM_STATUS_TYPE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
STATUS_ORDER_RULE_ID | NUMBER | Yes | Unique 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 | |
SYSTEM_STATUS_TYPE | VARCHAR2 | (30) | Yes | The lookup type which defines the system status codes for an object |
CURRENT_STATUS_CODE | VARCHAR2 | (30) | Yes | Current system status code |
NEXT_STATUS_CODE | VARCHAR2 | (30) | Yes | Next system status code |
SHOW_IN_LOV_FLAG | VARCHAR2 | (1) | Yes | Flag to indicate if the next status will be listed for the user to choose |
THEME_APPROVAL_FLAG | VARCHAR2 | (1) | Yes | Flag to indicate if theme approval is required for this status change |
BUDGET_APPROVAL_FLAG | VARCHAR2 | (1) | Yes | Flag to indicate if budget approval is required for this status change |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
APPLICATION_ID | NUMBER | (15) | Application Identifier |
Cut, paste (and edit) the following text to query this object:
SELECT STATUS_ORDER_RULE_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
, SYSTEM_STATUS_TYPE
, CURRENT_STATUS_CODE
, NEXT_STATUS_CODE
, SHOW_IN_LOV_FLAG
, THEME_APPROVAL_FLAG
, BUDGET_APPROVAL_FLAG
, SECURITY_GROUP_ID
, APPLICATION_ID
FROM AMS.AMS_STATUS_ORDER_RULES;
AMS.AMS_STATUS_ORDER_RULES does not reference any database object
AMS.AMS_STATUS_ORDER_RULES is referenced by following:
|
|
|