ONT Audit History

Description
Categories: BI Publisher
Application: Order Management
Source: Audit History Report (XML)
Short Name: OEXAUDHR_XML
DB package: ONT_OEXAUDHR_XMLP_PKG
Run ONT Audit History and other Oracle EBS reports with Blitz Report™ on our demo environment
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
Blitz Report™