ONT Audit History

Description
Categories: BI Publisher
Columns: History Date, Order Number, Old Display Value, New Display Value, User Name, Respon, Reason, Hist Comments, Lineid1, Ent Name ...
Application: Order Management
Source: Audit History Report (XML)
Short Name: OEXAUDHR_XML
DB package: ONT_OEXAUDHR_XMLP_PKG
select to_char(a.hist_creation_date,'DD-MON-YY HH24:MI') HISTORY_DATE,
           a.order_number,
           a.old_display_value,
           a.new_display_value,
           a.user_name,
           a.responsibility_name respon,
           a.reason,
           a.hist_comments,
           a.entity_number lineid1,
           a.entity_display_name ent_name,
           a.attribute_display_name att_name,
           a.entity_id eid,
           a.org_id  orgid, 
	ONT_OEXAUDHR_XMLP_PKG.cf_1formula(a.entity_id, a.entity_number) CF_lineno, 
	ONT_OEXAUDHR_XMLP_PKG.cf_no_data_found1formula(a.order_number) CF_NO_DATA_FOUND1
from    oe_audit_attr_desc_v a
where  trunc(a.hist_creation_date,'DD') >= trunc(:p_start_date,'DD')
 AND a.ORG_ID = MO_GLOBAL.GET_CURRENT_ORG_ID()
&p_where
order by a.hist_creation_date desc,a.entity_id asc
Parameter Name SQL text Validation
History Date (From)
 
Date
History Date (To)
 
Date
Entity Name
 
LOV Oracle
Attribute Name
 
LOV Oracle
Order Number (From)
 
LOV Oracle
Order Number (To)
 
LOV Oracle
User Name
 
LOV Oracle
Responsibility Name
 
LOV Oracle