Product: | PSP - Labor Distribution |
---|---|
Description: | Based on the PSP_SCHEDULE_LINES table used in Labor Schedules for Employees report |
Implementation/DBA Data: | APPS.PSP_REP_SCH_EMP_V |
SELECT A.PERSON_ID
, A.ASSIGNMENT_ID
, A.FTE
, D.ELEMENT_TYPE_ID
, D.ELEMENT_GROUP_ID
, D.SCHEDULING_TYPES_CODE
, G.PROJECT_ID
, G.TASK_ID
, G.AWARD_ID
, G.EXPENDITURE_ORGANIZATION_ID
, G.EXPENDITURE_TYPE
, G.GL_CODE_COMBINATION_ID
, G.SCHEDULE_PERCENT
, G.SCHEDULE_BEGIN_DATE
, G.SCHEDULE_END_DATE
, H.ORGANIZATION_ID
, A.BUSINESS_GROUP_ID
, A.SET_OF_BOOKS_ID
FROM PSP_SCHEDULES A
, PSP_SCHEDULE_HIERARCHY D
, PSP_SCHEDULE_LINES G
, PER_ASSIGNMENTS_F H
WHERE A.ASSIGNMENT_ID = D.ASSIGNMENT_ID
AND A.BUSINESS_GROUP_ID=D.BUSINESS_GROUP_ID
AND A.SET_OF_BOOKS_ID=D.SET_OF_BOOKS_ID
AND G.SCHEDULE_HIERARCHY_ID = D.SCHEDULE_HIERARCHY_ID
AND G.SCHEDULE_BEGIN_DATE BETWEEN H.EFFECTIVE_START_DATE
AND H.EFFECTIVE_END_DATE
AND A.ASSIGNMENT_ID = H.ASSIGNMENT_ID