PSP Organization Level Default Labor Schedule

➜ Back to Library
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
Download
Related Blitz Reports
PSP Reconciliation between sublines and distribution lines PSP Org. Default Labor Schedule PSP Distribution Default Account PSP Distribution Suspense Account FND Access Control 11i PSP Organization Default Usage Encumbrance FND Access Control CAC Inventory Accounts Setup PA Project Types
Blitz Report™

Blitz Report™ provides multiple benefits: