VIEW: APPS.PSP_REP_SCH_EMP_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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