[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | AMW_CONSTRAINTS_B |
|---|---|
| Object Type: | TABLE |
| Owner: | AMW |
| FND Design Data: |  AMW.AMW_CONSTRAINTS_B
|
| Subobject Name: | |
| Status: | VALID |
Holds information of Segregation of Duties Constraints
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| AMW_CONSTRAINTS_B_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 CONSTRAINT_REV_ID
|
| AMW_CONSTRAINTS_B_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CONSTRAINT_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
| LAST_UPDATED_BY | NUMBER | Yes | Standard Who column | |
| CREATION_DATE | DATE | Yes | Standard Who column | |
| CREATED_BY | NUMBER | Yes | Standard Who column | |
| LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield structure defining column | |
| ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield | |
| SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
| OBJECT_VERSION_NUMBER | NUMBER | This Column is used for locking purpose | ||
| CONSTRAINT_ID | NUMBER | Yes | Constraint Identifier. | |
| CONSTRAINT_REV_ID | NUMBER | Yes | Constraint Revision Identifier. A constraint can be revised after its creation. At present the constraint revision is not supported.So this column holds the constraint_Id value | |
| START_DATE | DATE | Yes | Start Date of the Constraint. | |
| END_DATE | DATE | End Date of the Constraint. | ||
| ENTERED_BY_ID | NUMBER | Yes | Holds the party_id of the valid ICM user who created this Constraint. | |
| TYPE_CODE | VARCHAR2 | (30) | Yes | The Type of the Constraint. The Constraint can be of Responsibility or Function Type. Following are the possible values and their meaning 1. ALL: User possessing all functions 2. ME : User possessing any two functions 3.SET : User possessing any two functions from two incompatible sets 4.RESPALL: User possessing all responsibilities 5. RESPME : User possessing any two responsibilities 6. RESPSET: User possessing any two responsibilities from two incompatible sets |
| RISK_ID | NUMBER | No longer used | ||
| APPROVAL_STATUS | VARCHAR2 | (30) | Not currently used | |
| CLASSIFICATION | NUMBER | Provides the way for customization of Constraint Definition. Based on the customer requirement , they can define a clsssification to handle customer specific additional constraint attributes. | ||
| OBJECTIVE_CODE | VARCHAR2 | (30) | A constraint can be defined in detective or preventive mode. Consider a constraint having two incompatible function. In preventive mode, it is the system administrator's responsibility to detect the violation of the constraint by a user or responsibility when a new responsibility is assigned to a user or a new function is assigned to a responsibility via a menu. In preventive mode, the system checks if assigning a responsibility to a user or assigning a function to a responsibility via menu will violate any constraints or not.If it violates the constraint, then system will not allow the assigning of the new responsibility to the user or assigning the function to a responsibility via menu | |
| CONTROL_ID | NUMBER | No longer used |
Cut, paste (and edit) the following text to query this object:
SELECT LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, SECURITY_GROUP_ID
, OBJECT_VERSION_NUMBER
, CONSTRAINT_ID
, CONSTRAINT_REV_ID
, START_DATE
, END_DATE
, ENTERED_BY_ID
, TYPE_CODE
, RISK_ID
, APPROVAL_STATUS
, CLASSIFICATION
, OBJECTIVE_CODE
, CONTROL_ID
FROM AMW.AMW_CONSTRAINTS_B;
AMW.AMW_CONSTRAINTS_B does not reference any database object
AMW.AMW_CONSTRAINTS_B is referenced by following:
APPS
AMW_CONSTRAINTS_B
|
|
|
|