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
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 |