ONT Audit History

➜ Back to Library
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
Download
Related Blitz Reports
QP Customer Pricing Engine Request ECC Oracle Asset Tracking, Oracle Asset Tracking: Instances ONT Defaulting Rules Listing AR Transactions and Lines XX AR Transactions and Lines PO Print CLM Requisitions CAC Intercompany SO Price List vs. Item Cost Comparison PO Print CLM Requisition Amendments PON Solicitation data template
Blitz Report™

Blitz Report™ provides multiple benefits: