View: AMW_VIOLATIONS_V

Product:	AMW - Internal Controls Manager
Description:	this view returns information about Segregation of Duties Constraint Violation
Implementation/DBA Data:	APPS.AMW_VIOLATIONS_V

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