HXC Timecard Audit Trail

Description
Categories: BI Publisher
Application: Time and Labor Engine
Source: OTL: Timecard Audit Trail Report
Short Name: HXCRPTAUD
DB package: HXC_RPT_TC_AUDIT_TRAIL
Run HXC Timecard Audit Trail and other Oracle EBS reports with Blitz Report™ on our demo environment
    SELECT TO_CHAR(TIME_ENTRY_DATE,'dd-MON-yyyy') ENTRY_DATE,
           ATTRIBUTE_INFO,
	   NVL(start_stop_time,hours) HOURS,
	   ACTION,
	   TO_CHAR(ACTION_DATE,'dd-MON-yy HH24:MI:SS') ACTION_BY_DATE,
	   ACTION_BY,
	   COMMENTS,
	   CLA_REASON,
	   RESOURCE_NAME,
	   TO_CHAR(TC_START_TIME,'dd-MON-yyyy') START_TIME,
	   TO_CHAR(TC_STOP_TIME,'dd-MON-yyyy') STOP_TIME,
	   SUBSTR(ACTION_TYPE,1,1) ACTION_ON
      FROM hxc_rpt_tc_audit
     ORDER 
        BY resource_name,
           tc_start_time,
           transaction_id,
           TRUNC(time_entry_date),
	   action_type,
	   action_date
Parameter Name SQL text Validation
From Date
 
Date
To Date
 
Date
Delete and Regenerate Data?
 
LOV Oracle
Display Records with Working Status?
 
LOV Oracle
Organization
 
LOV Oracle
Location
 
LOV Oracle
Payroll
 
LOV Oracle
Supervisor
 
LOV Oracle
Person
 
LOV Oracle
Blitz Report™