PSP Organization Level Default Labor Schedule

Description
Categories: BI Publisher
Columns: Organization Id, Assignment Id, Person Id, Element Type Id, Schedule Begin Date, Schedule End Date, Gl Code Combination Id, Project Id, Expenditure Organization Id, Expenditure Type ...
Application: Labor Distribution
Source: PSP: Organization Level Default Labor Schedule Report (XML)
Short Name: PSPLSODL_XML
DB package: PSP_PSPLSODL_XMLP_PKG
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
P_BUSINESS_GROUP_ID
 
Number
P_SET_OF_BOOKS_ID
 
Number
PSP_REPORT_TYPE