PSP Organization Level Default Labor Schedule

Description
Categories: BI Publisher
Imported from BI Publisher
Description: Organization Level Default Labor Schedule Report
Application: Labor Distribution
Source: PSP: Organization Level Default Labor Schedule Report (XML)
Short Name: PSPLSODL_XML
DB package: PSP_PSPLSODL_XMLP_PKG
Run PSP Organization Level Default Labor Schedule and other Oracle EBS reports with Blitz Report™ on our demo environment
Select 	a.ORGANIZATION_ID,
        	a.ASSIGNMENT_ID,
        	a.PERSON_ID,
	a.ELEMENT_TYPE_ID,
	a.SCHEDULE_BEGIN_DATE,
	a.SCHEDULE_END_DATE,
	b.GL_CODE_COMBINATION_ID,
	b.PROJECT_ID,
	b.EXPENDITURE_ORGANIZATION_ID,
	b.EXPENDITURE_TYPE,
	b.TASK_ID,
	b.AWARD_ID,
	b.SCHEDULE_BEGIN_DATE DEFAULT_BEGIN_DATE,
	b.SCHEDULE_END_DATE DEFAULT_END_DATE,
	PSP_PSPLSODL_XMLP_PKG.cf_organization_nameformula(a.ORGANIZATION_ID) CF_ORGANIZATION_NAME,
	PSP_PSPLSODL_XMLP_PKG.cf_gl_accountformula(b.GL_CODE_COMBINATION_ID) CF_GL_ACCOUNT,
	PSP_PSPLSODL_XMLP_PKG.cf_project_nameformula(b.PROJECT_ID) CF_PROJECT_NAME,
	PSP_PSPLSODL_XMLP_PKG.cf_task_nameformula(b.TASK_ID, b.PROJECT_ID) CF_Task_Name,
	PSP_PSPLSODL_XMLP_PKG.cf_award_nameformula(b.AWARD_ID) CF_Award_Name,
	PSP_PSPLSODL_XMLP_PKG.cf_exp_org_nameformula(b.EXPENDITURE_ORGANIZATION_ID) CF_EXP_ORG_NAME,
	PSP_PSPLSODL_XMLP_PKG.cf_default_begin_dateformula(b.SCHEDULE_BEGIN_DATE, :CF_date_format) CF_default_begin_date,
	PSP_PSPLSODL_XMLP_PKG.cf_default_end_dateformula(b.SCHEDULE_END_DATE, :CF_date_format) CF_default_end_date,
	PSP_PSPLSODL_XMLP_PKG.cf_earnings_elementformula(a.ELEMENT_TYPE_ID) CF_EARNINGS_ELEMENT,
	PSP_PSPLSODL_XMLP_PKG.cf_employee_idformula(a.PERSON_ID) CF_EMPLOYEE_ID,
	PSP_PSPLSODL_XMLP_PKG.cf_person_nameformula(a.PERSON_ID) CF_Person_Name,
	PSP_PSPLSODL_XMLP_PKG.cf_assignment_numberformula(a.ASSIGNMENT_ID, a.PERSON_ID) CF_Assignment_Number,
	PSP_PSPLSODL_XMLP_PKG.cf_schedule_begin_dateformula(a.SCHEDULE_BEGIN_DATE, :CF_date_format, a.SCHEDULE_END_DATE) CF_schedule_begin_date,
	PSP_PSPLSODL_XMLP_PKG.cf_schedule_end_dateformula(a.SCHEDULE_END_DATE, :CF_date_format) CF_schedule_end_date,
	PSP_PSPLSODL_XMLP_PKG.cf_number_working_daysformula(a.SCHEDULE_BEGIN_DATE, a.SCHEDULE_END_DATE) CF_NUMBER_WORKING_DAYS
from 	PSP_REP_ORG_DLS a,
	PSP_DEFAULT_LABOR_SCHEDULES b
where 	a.ORG_DLS_BATCH_ID = :P_BATCH_ID1
and	a.SCHEDULE_LINE_ID = b.ORG_SCHEDULE_ID
and b.business_group_id = :P_BUSINESS_GROUP_ID
and b.set_of_books_id = :P_SET_OF_BOOKS_ID
group by a.ORGANIZATION_ID,
	b.GL_CODE_COMBINATION_ID,
	b.PROJECT_ID,
	b.EXPENDITURE_ORGANIZATION_ID,
	b.EXPENDITURE_TYPE,
	b.TASK_ID,
	b.AWARD_ID,
	b.SCHEDULE_BEGIN_DATE,
	b.SCHEDULE_END_DATE,
	a.ELEMENT_TYPE_ID,
        	a.PERSON_ID,
        	a.ASSIGNMENT_ID,
	a.SCHEDULE_BEGIN_DATE,
	a.SCHEDULE_END_DATE
	order by 15, 16, 17, 18, 19, 20, 10, 13, 14, 23, 24, 25, 26, 27, 28, 29
Parameter Name SQL text Validation
Organization Set
 
LOV Oracle
Begin Date
 
Date
End Date
 
Date
Blitz Report™