WIP Employee Rates Listing
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Employee Rates Listing
Application: Work in Process
Source: Employee Rates Listing (XML)
Short Name: WIPSUEMP_XML
DB package: WIP_WIPSUEMP_XMLP_PKG
Description: Employee Rates Listing
Application: Work in Process
Source: Employee Rates Listing (XML)
Short Name: WIPSUEMP_XML
DB package: WIP_WIPSUEMP_XMLP_PKG
Run
WIP Employee Rates Listing and other Oracle EBS reports with Blitz Report™ on our demo environment
select (round(w1.hourly_labor_rate, :p_precision)) hourly_labor_rate , w1.effective_date , w1.employee_id from wip_employee_labor_rates w1 where w1.effective_date != (SELECT NVL(MAX(w2.effective_date),SYSDATE) FROM wip_employee_labor_rates w2 WHERE w2.employee_id = w1.employee_id AND w2.organization_id = :P_Organization_Id AND w2.effective_date <= SYSDATE) and w1.organization_id = :P_Organization_Id &Limit_Dates and w1.employee_id=:EMPLOYEE_ID_Q_Emp order by w1.employee_id, w1.effective_date desc |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Display in Detail |
|
LOV Oracle | |
Current Only |
|
LOV Oracle | |
Employees From |
|
LOV Oracle | |
To |
|
LOV Oracle | |
Dates From |
|
Date | |
To 2 |
|
Date |
Blitz Report™