HXT Total Hours To BEE

➜ Back to Library
Description
Categories: BI Publisher
Application: Time and Labor
Source: Total Hours To BEE (XML)
Short Name: HXT007A_XML
DB package: HXT_HXT007A_XMLP_PKG
Run HXT Total Hours To BEE and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT pbl.batch_id batch_id1,
             pbl.element_type_id,
             pbl.value_1,
             pbl.value_2,
             pbl.value_3,
             pbl.value_4,
             pbl.value_5,
             pbl.value_6,
             pbl.value_7,
             pbl.value_8,
             pbl.value_9,
             pbl.value_10,
             pbl.value_11,
             pbl.value_12,
             pbl.value_13,
             pbl.value_14,
             pbl.value_15, 
	HXT_HXT007A_XMLP_PKG.cf_bee_line_hoursformula(pbl.element_type_id, pbl.value_1, pbl.value_2, pbl.value_3, pbl.value_4, pbl.value_5, pbl.value_6, pbl.value_7, pbl.value_8, pbl.value_9, pbl.value_10, pbl.value_11, pbl.value_12, pbl.value_13, pbl.value_14, pbl.value_15) CF_BEE_LINE_HOURS
FROM hxt_pay_element_types_f_ddf_v hpet,
             pay_batch_lines pbl
WHERE hpet.element_type_id = pbl.element_type_id
     AND :P_DATE_EARNED BETWEEN hpet.effective_start_date AND hpet.effective_end_date
     AND hpet.hxt_earning_category IN ('REG', 'OVT', 'ABS') 
 and pbl.batch_id=:batch_id
Parameter Name SQL text Validation
Payroll Name 
 
 LOV Oracle
Process Date 
 
 Date
Download
Related Blitz Reports
HXT Earning Variance Calculation HXT Location Variance Calculation HXT Organization Variance Calc HXT Actual and Rounded Time Punch HXT Person/Assignment Table List HXT OTLR Missing Timecard PON Solicitation data template PO Endeca Template HXT Work Plan Table Listing
Blitz Report™

Blitz Report™ provides multiple benefits: