ONT Audit History

Description

Categories
Enginatics
Repository
GitHub
Order Management audit history report showing changes to order headers, lines, sales credits, and price adjustments with old/new values, change reasons, and the user who made the change.
Based on Oracle standard report OEXAUDHR_XML (Audit History Report).

SQL 58 lines

Parameters 9

ParameterTypeList of values SQL
Operating UnitLOV
haouv.name=:operating_unit
History Date FromDate
oaadv.hist_creation_date>=:history_date_from
History Date ToDate
oaadv.hist_creation_date<:history_date_to+1
EntityLOV
oaadv.entity_id=:entity_id
AttributeLOV
oaadv.attribute_id=:attribute_id
Order Number FromNumber
oaadv.order_number>=:order_number_from
Order Number ToNumber
oaadv.order_number<=:order_number_to
User NameLOV
oaadv.user_name=:user_name
ResponsibilityLOV
oaadv.responsibility_name=:responsibility