VIEW: APPS.OE_AUDIT_ATTR_DESC_V

Source

View Text - Preformatted

SELECT hst.entity_id , oep.entity_display_name, hst.attribute_id, oe_audit_history_pvt.get_display_name(hst.attribute_id,hst.new_context_value,hst.old_context_value), oe_audit_history_pvt.id_to_value(hst.attribute_id,hst.old_attribute_value,hst.old_context_value,hst.org_id), oe_audit_history_pvt.id_to_value(hst.attribute_id,hst.new_attribute_value,hst.new_context_value,hst.org_id), hst.hist_creation_date, hst.order_number, hst.entity_number, hst.org_id, oel.meaning, hst.change_comments, hst.user_id, fu.USER_NAME, hst.responsibility_id, fr.RESPONSIBILITY_NAME, hst.old_context_value, hst.new_context_value FROM oe_audit_attr_history hst, fnd_responsibility_tl fr, fnd_user fu, oe_pc_entities_v oep, oe_lookups oel WHERE fr.responsibility_id = hst.responsibility_id and fu.user_id = hst.user_id and oel.lookup_type(+)='CANCEL_CODE' and oel.lookup_code(+)=hst.reason_code and oep.entity_id=hst.entity_id and fr.language = userenv('LANG')

View Text - HTML Formatted

SELECT HST.ENTITY_ID
, OEP.ENTITY_DISPLAY_NAME
, HST.ATTRIBUTE_ID
, OE_AUDIT_HISTORY_PVT.GET_DISPLAY_NAME(HST.ATTRIBUTE_ID
, HST.NEW_CONTEXT_VALUE
, HST.OLD_CONTEXT_VALUE)
, OE_AUDIT_HISTORY_PVT.ID_TO_VALUE(HST.ATTRIBUTE_ID
, HST.OLD_ATTRIBUTE_VALUE
, HST.OLD_CONTEXT_VALUE
, HST.ORG_ID)
, OE_AUDIT_HISTORY_PVT.ID_TO_VALUE(HST.ATTRIBUTE_ID
, HST.NEW_ATTRIBUTE_VALUE
, HST.NEW_CONTEXT_VALUE
, HST.ORG_ID)
, HST.HIST_CREATION_DATE
, HST.ORDER_NUMBER
, HST.ENTITY_NUMBER
, HST.ORG_ID
, OEL.MEANING
, HST.CHANGE_COMMENTS
, HST.USER_ID
, FU.USER_NAME
, HST.RESPONSIBILITY_ID
, FR.RESPONSIBILITY_NAME
, HST.OLD_CONTEXT_VALUE
, HST.NEW_CONTEXT_VALUE
FROM OE_AUDIT_ATTR_HISTORY HST
, FND_RESPONSIBILITY_TL FR
, FND_USER FU
, OE_PC_ENTITIES_V OEP
, OE_LOOKUPS OEL
WHERE FR.RESPONSIBILITY_ID = HST.RESPONSIBILITY_ID
AND FU.USER_ID = HST.USER_ID
AND OEL.LOOKUP_TYPE(+)='CANCEL_CODE'
AND OEL.LOOKUP_CODE(+)=HST.REASON_CODE
AND OEP.ENTITY_ID=HST.ENTITY_ID
AND FR.LANGUAGE = USERENV('LANG')