PSP Org. Default Labor Schedule

➜ Back to Library
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
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
Download
 
Related Blitz Reports
PA Project Types PSP Reconciliation between sublines and distribution lines PSP Organization Level Default Labor Schedule ECC Projects, Projects Costing: Transactions, SQL1 ECC Projects, Projects Costing: PSI Summary PA Project Configuration PA Implementation Options FND Access Control 11i CAC Inventory Accounts Setup
Blitz Report™

Blitz Report™ provides multiple benefits: