HXT Time Entry Detail

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
Blitz Report™