[Home] [Help]
View: AP_POL_VIOLATIONS_V
View Text
SELECT AV.REPORT_HEADER_ID
, AV.DISTRIBUTION_LINE_NUMBER
, AV.VIOLATION_NUMBER
, AV.VIOLATION_TYPE
, AV.ALLOWABLE_AMOUNT
, LC.DISPLAYED_FIELD
FROM AP_POL_VIOLATIONS AV
, AP_LOOKUP_CODES LC
WHERE LC.LOOKUP_TYPE = 'OIE_POL_VIOLATION_TYPES'
AND AV.VIOLATION_TYPE = LC.LOOKUP_CODE
Columns
Name |
REPORT_HEADER_ID |
DISTRIBUTION_LINE_NUMBER |
VIOLATION_NUMBER |
VIOLATION_TYPE |
ALLOWABLE_AMOUNT |
DISPLAYED_FIELD |