PSP Org. Default Labor Schedule
Description
- Categories
- BI Publisher
- Application
- Labor Distribution
- Source
- PSP: Org. Default Labor Schedule Report (XML)
- Short Name
- PSPLSODR_XML
- DB package
- PSP_PSPLSODR_XMLP_PKG
Imported from BI Publisher
Org. Default Labor Schedule Report
Org. Default Labor Schedule Report
SQL 34 lines
SELECT hou.organization_id, hou.name, pdls.project_id, pdls.award_id, pdls.expenditure_organization_id, pdls.expenditure_type, pdls.task_id, pdls.gl_code_combination_id, pdls.set_of_books_id, pdls.schedule_begin_date, pdls.schedule_end_date, pdls.schedule_percent, nvl(org_schedule_id, -99) org_schedule_id, PSP_PSPLSODR_XMLP_PKG.CF_GL_DESCFORMULA(pdls.gl_code_combination_id) CF_GL_DESC, PSP_PSPLSODR_XMLP_PKG.CF_TASK_NAMEFORMULA(pdls.project_id,pdls.task_id) CF_TASK_NAME, PSP_PSPLSODR_XMLP_PKG.CF_ORG_NAMEFORMULA(pdls.expenditure_organization_id) CF_ORG_NAME, PSP_PSPLSODR_XMLP_PKG.CF_AWARD_NUMBERFormula(pdls.award_id) CF_AWARD_NUMBER, PSP_PSPLSODR_XMLP_PKG.CF_PROJECT_NUMBERFORMULA(pdls.project_id) CF_PROJECT_NUMBER, PSP_PSPLSODR_XMLP_PKG.CF_sch_begin_date_dispFormula(pdls.schedule_begin_date,:CF_date_format) CF_SCH_BEGIN_DATE_DISP, PSP_PSPLSODR_XMLP_PKG.CF_sch_end_date_dispFormula(pdls.schedule_end_date,:CF_date_format) CF_SCH_END_DATE_DISP, PSP_PSPLSODR_XMLP_PKG.CF_ORG_SCHEDULE_IDFORMULA(nvl(org_schedule_id, -99)) CF_ORG_SCHEDULE_ID FROM psp_default_labor_schedules pdls, hr_organization_units hou WHERE &p_organization_id AND hou.organization_id = pdls.organization_id(+) AND nvl(pdls.schedule_begin_date, :p_end_date) <= :p_end_date AND nvl(pdls.schedule_end_date, :p_begin_date) >= :p_begin_date AND hou.business_group_id = :p_business_group_id AND (( pdls.set_of_books_id = :p_set_of_books_id) OR (pdls.set_of_books_id IS NULL) ) ORDER BY 2 ASC , hou.name |
Parameters 4
| Parameter | Type | List of values SQL |
|---|---|---|
| Organization Set | LOV Oracle | |
| Report Type | LOV Oracle | |
| Begin Date | Date | |
| End Date | Date |