Product: | PSP - Labor Distribution |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT PSH.SCHEDULE_HIERARCHY_ID
, PSH.SCHEDULING_TYPES_CODE
, PSH.ASSIGNMENT_ID
, PAA.ASSIGNMENT_NUMBER
, PSH.ELEMENT_GROUP_ID
, PSH.ELEMENT_TYPE_ID
, PSH.SET_OF_BOOKS_ID
, GL.NAME
, PSH.BUSINESS_GROUP_ID
, HOU.NAME
, PSH.LAST_UPDATE_DATE
, PSH.LAST_UPDATED_BY
, PSH.CREATED_BY
, PSH.CREATION_DATE
, PEG.ELEMENT_GROUP_NAME
FROM PSP_SCHEDULE_HIERARCHY PSH
, PSP_ELEMENT_GROUPS PEG
, PER_ALL_ASSIGNMENTS_F PAA
, HR_ALL_ORGANIZATION_UNITS HOU
, GL_SETS_OF_BOOKS GL
WHERE PSH.ELEMENT_GROUP_ID = PEG.ELEMENT_GROUP_ID(+)
AND (PSH.ASSIGNMENT_ID = PAA.ASSIGNMENT_ID
AND SYSDATE BETWEEN PAA.EFFECTIVE_START_DATE
AND PAA.EFFECTIVE_END_DATE)
AND PSH.BUSINESS_GROUP_ID= HOU.ORGANIZATION_ID
AND PSH.SET_OF_BOOKS_ID = GL.SET_OF_BOOKS_ID WITH READ ONLY