PSP Org. Default Labor Schedule
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Org. Default Labor Schedule Report
Application: Labor Distribution
Source: PSP: Org. Default Labor Schedule Report (XML)
Short Name: PSPLSODR_XML
DB package: PSP_PSPLSODR_XMLP_PKG
Description: Org. Default Labor Schedule Report
Application: Labor Distribution
Source: PSP: Org. Default Labor Schedule Report (XML)
Short Name: PSPLSODR_XML
DB package: PSP_PSPLSODR_XMLP_PKG
Run
PSP Org. Default Labor Schedule and other Oracle EBS reports with Blitz Report™ on our demo environment
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 |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Organization Set |
|
LOV Oracle | |
Report Type |
|
LOV Oracle | |
Begin Date |
|
Date | |
End Date |
|
Date |