ONT Audit History

➜ Back to Library
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
Download
Related Blitz Reports
ECC Oracle Asset Tracking, Oracle Asset Tracking: Instances, SQL1 PO Print CLM Requisition Amendments PO Print CLM Requisitions ONT Defaulting Rules Listing PO IDV Modification ECC Service Contracts, Service Contract Details, SQL1 ECC Sourcing, Negotiations, SQL1 XTR Admin - Audit Summary PON Solicitation data template
Blitz Report In Action
Blitz Report™

Blitz Report™ provides multiple benefits: