VIEW: APPS.AMW_VIOLATIONS_V

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)