HXT Time Entry Detail

➜ Back to Library
Description
Categories: BI Publisher
Application: Time and Labor
Source: OTL: Time Entry Detail Report
Short Name: HXTDETRPT
DB package: HXT_DET_HRS_WORKED_RPT
Run HXT Time Entry Detail and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT  /*+ INDEX(v.det HXT_DET_HOURS_RPT_N1)*/
        v.full_name
       ,v.person_id
       ,v.organization_id
       ,to_char (v.date_worked,fnd_profile.value ('ICX_DATE_FORMAT_MASK')) date_worked
       ,v.hours Hours
       ,v.time_in
       ,v.time_out
       ,v.element_name
	   ,v.sum_time_building_block_id
       ,(CASE
        WHEN    v.sum_start_time IS NULL
                THEN    to_char (v.sum_measure)
        ELSE    to_char (v.sum_start_time,'HH24:MI')|| ' - '|| to_char (v.sum_stop_time,'HH24:MI') END) time_entered
       ,v.period_name
       ,v.earning_policy_name
       ,v.stage
FROM    hxt_det_hours_worked_rpt_v v
WHERE   v.person_id = nvl (:p_person_id,v.person_id)
AND     v.organization_id = nvl (:p_organization_id,v.organization_id)
AND     v.payroll_id = nvl (:p_payroll_id,v.payroll_id)
AND     v.date_worked BETWEEN :p_from_date AND :p_to_date
ORDER BY v.full_name ASC
        ,v.date_worked ASC
        ,v.sum_time_building_block_id ASC
        ,v.element_name ASC
Parameter Name SQL text Validation
From Date 
 
 Date
To Date 
 
 Date
Person 
 
 LOV Oracle
Organization 
 
 LOV Oracle
Payroll 
 
 LOV Oracle
Download
Related Blitz Reports
HXT Location Variance Calculation HXT OTLR Missing Timecard HXT Organization Variance Calc HXT Actual and Rounded Time Punch HXT Periodic Late Clock-In HXT Earning Variance Calculation HXT Time Management to Project Accounting Retrieval HXT Person/Assignment Table List HXT Total Hours To BEE
Blitz Report™

Blitz Report™ provides multiple benefits: