Product: | PSP - Labor Distribution |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT PER.EFFORT_REPORT_ID
, PER.VERSION_NUM
, PER.VERSION_CREATION_DATE
, PER.SET_OF_BOOKS_ID
, GL.NAME
, PER.BUSINESS_GROUP_ID
, HOU.NAME
, PER.MESSAGE_ID
, PER.REPORT_COMMENT
, '_LA:STATUS_CODE:PSP_LOOKUPS:PSP_STATUS_CODE:MEANING'
, PER.TEMPLATE_ID
, PERT.TEMPLATE_NAME
, PER.PREV_EFFORT_REPORT_ID
, PER.PERSON_ID
, PER.LAST_UPDATE_DATE
, PER.LAST_UPDATED_BY
, PER.CREATED_BY
, PER.CREATION_DATE
, PEM.EFFORT_REPORT_MESSAGE_TYPE
, PEM.TEXT
, PPF.EMPLOYEE_NUMBER
, PPF.FIRST_NAME
, PPF.LAST_NAME
FROM PSP_EFFORT_REPORTS PER
, PSP_EFFORT_MESSAGES PEM
, PER_ALL_PEOPLE_F PPF
, PSP_EFFORT_REPORT_TEMPLATES PERT
, GL_SETS_OF_BOOKS GL
, HR_ALL_ORGANIZATION_UNITS HOU
WHERE PER.MESSAGE_ID = PEM.MESSAGE_ID(+)
AND (PER.PERSON_ID = PPF.PERSON_ID
AND PER.VERSION_CREATION_DATE BETWEEN PPF.EFFECTIVE_START_DATE
AND PPF.EFFECTIVE_END_DATE)
AND PER.TEMPLATE_ID=PERT.TEMPLATE_ID
AND PER.BUSINESS_GROUP_ID=HOU.ORGANIZATION_ID
AND PER.SET_OF_BOOKS_ID=GL.SET_OF_BOOKS_ID WITH READ ONLY