Product: | ONT - Order Management |
---|---|
Description: | |
Implementation/DBA Data: | APPS.OE_AUDIT_ATTR_DESC_V |
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')