eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: AP.AP_POL_VIOLATIONS_ARC#

Source

View Text - Preformatted


select ARC_REQ_ID ARC_REQ_ID, ARCHIVE_DATE ARCHIVE_DATE, REPORT_HEADER_ID REPORT_HEADER_ID, DISTRIBUTION_LINE_NUMBER DISTRIBUTION_LINE_NUMBER, VIOLATION_NUMBER VIOLATION_NUMBER, VIOLATION_TYPE VIOLATION_TYPE, ALLOWABLE_AMOUNT ALLOWABLE_AMOUNT, FUNC_CURRENCY_ALLOWABLE_AMT FUNC_CURRENCY_ALLOWABLE_AMT, ORG_ID ORG_ID, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LAST_UPDATE_DATE LAST_UPDATE_DATE, EXCEEDED_AMOUNT EXCEEDED_AMOUNT, VIOLATION_DATE VIOLATION_DATE, DUP_REPORT_HEADER_ID DUP_REPORT_HEADER_ID, DUP_REPORT_LINE_ID DUP_REPORT_LINE_ID, DUP_DIST_LINE_NUMBER DUP_DIST_LINE_NUMBER from "AP"."AP_POL_VIOLATIONS_ARC"

View Text - HTML Formatted

SELECT ARC_REQ_ID ARC_REQ_ID
, ARCHIVE_DATE ARCHIVE_DATE
, REPORT_HEADER_ID REPORT_HEADER_ID
, DISTRIBUTION_LINE_NUMBER DISTRIBUTION_LINE_NUMBER
, VIOLATION_NUMBER VIOLATION_NUMBER
, VIOLATION_TYPE VIOLATION_TYPE
, ALLOWABLE_AMOUNT ALLOWABLE_AMOUNT
, FUNC_CURRENCY_ALLOWABLE_AMT FUNC_CURRENCY_ALLOWABLE_AMT
, ORG_ID ORG_ID
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, EXCEEDED_AMOUNT EXCEEDED_AMOUNT
, VIOLATION_DATE VIOLATION_DATE
, DUP_REPORT_HEADER_ID DUP_REPORT_HEADER_ID
, DUP_REPORT_LINE_ID DUP_REPORT_LINE_ID
, DUP_DIST_LINE_NUMBER DUP_DIST_LINE_NUMBER
FROM "AP"."AP_POL_VIOLATIONS_ARC"