[Home] [Help]
View: AMW_VIOLATIONS_V
| Product: | AMW - Internal Controls Manager (Obsolete) |
|---|
| Description: | this view returns information about Segregation of Duties Constraint Violation |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT C.CONSTRAINT_NAME
, V.CONSTRAINT_REV_ID
, V.REQUEST_ID
, V.REQUEST_DATE
, V.VIOLATOR_NUM
, V.REQUESTED_BY_ID
, PARTIES.FULL_NAME
, AMWLKUPV.MEANING
, V.STATUS_CODE
, AMWLKUPV.DESCRIPTION
, V.VIOLATION_ID
FROM AMW_VIOLATIONS V
, AMW_CONSTRAINTS_VL C
, AMW_EMPLOYEES_CURRENT_V PARTIES
, AMW_LOOKUPS AMWLKUPV
, AMW_LOOKUPS AMWLKUPC
WHERE C.CONSTRAINT_REV_ID=V.CONSTRAINT_REV_ID
AND V.REQUESTED_BY_ID=PARTIES.PARTY_ID (+)
AND (AMWLKUPV.LOOKUP_TYPE = 'AMW_VIOLATION_STATUS'
AND AMWLKUPV.LOOKUP_CODE = V.STATUS_CODE)
AND (AMWLKUPC.LOOKUP_TYPE = 'AMW_CONSTRAINT_TYPE'
AND AMWLKUPC.LOOKUP_CODE = C.TYPE_CODE)
Columns
| Name |
| CONSTRAINT_NAME |
| CONSTRAINT_REV_ID |
| REQUEST_ID |
| REQUEST_DATE |
| VIOLATOR_NUM |
| REQUESTED_BY_ID |
| REQUESTED_BY_NAME |
| STATUS_MEANING |
| STATUS_CODE |
| TYPE_DESCRIPTION |
| VIOLATION_ID |