[Home] [Help] [Dependency Information]
Object Name: | AMW_CONSTRAINT_INTERFACE |
---|---|
Object Type: | TABLE |
Owner: | AMW |
FND Design Data: | AMW.AMW_CONSTRAINT_INTERFACE |
Subobject Name: | |
Status: | VALID |
Stores the information required to create Constraint through Webadi
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AMW_CONSTRAINT_INTERFACE_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | CST_INTERFACE_ID |
AMW_CONSTRAINT_INTERFACE_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
BATCH_ID
CREATED_BY |
AMW_CONSTRAINT_INTERFACE_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
CST_NAME
CREATED_BY BATCH_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BATCH_ID | NUMBER | Stores the Batch Id. | ||
CST_NAME | VARCHAR2 | (240) | Yes | Stores the Constraint Name |
CST_DESCRIPTION | VARCHAR2 | (4000) | Stores the Constraint Description | |
CST_APPROVAL_STATUS_CODE | VARCHAR2 | (30) | Not currently used | |
CST_START_DATE | DATE | Yes | Stores the Constraint Start Date | |
CST_END_DATE | DATE | Stores the Constraint End Date | ||
RISK_NAME | NUMBER | No longer used | ||
ENTERED_BY_ID | NUMBER | Yes | Stores the party_id of the valid ICM user who created this Constraint. | |
CST_TYPE_CODE | VARCHAR2 | (30) | Yes | Stores 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 |
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 | ||
ERROR_FLAG | VARCHAR2 | (1) | Stores the Error Flag. Initialy the error flag is NULL. During validation check, if any of the constraint detail is invalid, the Error_Flag is set to Y | |
INTERFACE_STATUS | VARCHAR2 | (2000) | Stores the validation error messages | |
PROCESS_FLAG | VARCHAR2 | (1) | Stores the Process Flag. Initially it is NULL. After uploading the valid constraint details into the constraint specific tables, the Process_Flag is set to Y for records having error_flag as null. | |
CST_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield structure defining column | |
CST_ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
CST_ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
CST_ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
CST_ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
CST_ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
CST_ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
CST_ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
CST_ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
CST_ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
CST_ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
CST_ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
CST_ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
CST_ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
CST_ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
CST_ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
CST_INTERFACE_ID | NUMBER | Yes | Stores the Interface Identifier | |
CST_ENTRIES_FUNCTION_ID | NUMBER | Store the incompatible function/Concurrent Program Id | ||
CST_ENTRIES_RESP_ID | NUMBER | Stores the Incompatible Responsibility Id | ||
CST_ENTRIES_GROUP_CODE | VARCHAR2 | (30) | Stores the Incompatible Set to which this Incompatible function belongs to | |
CST_VIOLAT_OBJ_TYPE | VARCHAR2 | (30) | Store the Incompatible Function Type. The possible values are FUNC - The Fnd Form Function, CP - The Fnd Concurrent Program Id | |
CST_ENTRIES_APPL_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT BATCH_ID
, CST_NAME
, CST_DESCRIPTION
, CST_APPROVAL_STATUS_CODE
, CST_START_DATE
, CST_END_DATE
, RISK_NAME
, ENTERED_BY_ID
, CST_TYPE_CODE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, ERROR_FLAG
, INTERFACE_STATUS
, PROCESS_FLAG
, CST_ATTRIBUTE_CATEGORY
, CST_ATTRIBUTE1
, CST_ATTRIBUTE2
, CST_ATTRIBUTE3
, CST_ATTRIBUTE4
, CST_ATTRIBUTE5
, CST_ATTRIBUTE6
, CST_ATTRIBUTE7
, CST_ATTRIBUTE8
, CST_ATTRIBUTE9
, CST_ATTRIBUTE10
, CST_ATTRIBUTE11
, CST_ATTRIBUTE12
, CST_ATTRIBUTE13
, CST_ATTRIBUTE14
, CST_ATTRIBUTE15
, CST_INTERFACE_ID
, CST_ENTRIES_FUNCTION_ID
, CST_ENTRIES_RESP_ID
, CST_ENTRIES_GROUP_CODE
, CST_VIOLAT_OBJ_TYPE
, CST_ENTRIES_APPL_ID
FROM AMW.AMW_CONSTRAINT_INTERFACE;
AMW.AMW_CONSTRAINT_INTERFACE does not reference any database object
AMW.AMW_CONSTRAINT_INTERFACE is referenced by following:
|
|
|