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: ONT.OE_AUDIT_ATTR_HISTORY#

Source

View Text - Preformatted


select ENTITY_ID ENTITY_ID, ATTRIBUTE_ID ATTRIBUTE_ID, OLD_ATTRIBUTE_VALUE OLD_ATTRIBUTE_VALUE, NEW_ATTRIBUTE_VALUE NEW_ATTRIBUTE_VALUE, REASON REASON, HIST_CREATION_DATE HIST_CREATION_DATE, ORDER_NUMBER ORDER_NUMBER, ENTITY_NUMBER ENTITY_NUMBER, ORG_ID ORG_ID, REASON_CODE REASON_CODE, RESPONSIBILITY_ID RESPONSIBILITY_ID, USER_ID USER_ID, ORDER_TYPE_ID ORDER_TYPE_ID, SOLD_TO_ORG_ID SOLD_TO_ORG_ID, CHANGE_COMMENTS CHANGE_COMMENTS, ENTITY_NUMBER2 ENTITY_NUMBER2, OLD_CONTEXT_VALUE OLD_CONTEXT_VALUE, NEW_CONTEXT_VALUE NEW_CONTEXT_VALUE from "ONT"."OE_AUDIT_ATTR_HISTORY"

View Text - HTML Formatted

SELECT ENTITY_ID ENTITY_ID
, ATTRIBUTE_ID ATTRIBUTE_ID
, OLD_ATTRIBUTE_VALUE OLD_ATTRIBUTE_VALUE
, NEW_ATTRIBUTE_VALUE NEW_ATTRIBUTE_VALUE
, REASON REASON
, HIST_CREATION_DATE HIST_CREATION_DATE
, ORDER_NUMBER ORDER_NUMBER
, ENTITY_NUMBER ENTITY_NUMBER
, ORG_ID ORG_ID
, REASON_CODE REASON_CODE
, RESPONSIBILITY_ID RESPONSIBILITY_ID
, USER_ID USER_ID
, ORDER_TYPE_ID ORDER_TYPE_ID
, SOLD_TO_ORG_ID SOLD_TO_ORG_ID
, CHANGE_COMMENTS CHANGE_COMMENTS
, ENTITY_NUMBER2 ENTITY_NUMBER2
, OLD_CONTEXT_VALUE OLD_CONTEXT_VALUE
, NEW_CONTEXT_VALUE NEW_CONTEXT_VALUE
FROM "ONT"."OE_AUDIT_ATTR_HISTORY"