Product: | PSP - Labor Distribution |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT PES.ENC_SUMMARY_LINE_ID
, PES.BUSINESS_GROUP_ID
, HOU.NAME BUSINESS_GRP_NAME
, PES.GMS_BATCH_NAME
, PES.TIME_PERIOD_ID
, PTP.PERIOD_NAME
, PES.PERSON_ID
, PPF.FIRST_NAME
, PPF.LAST_NAME
, PES.ASSIGNMENT_ID
, PAA.ASSIGNMENT_NUMBER
, PES.EFFECTIVE_DATE
, PES.SET_OF_BOOKS_ID
, GL.NAME SET_OF_BOOKS_NAME
, '_KF:SQLGL:GL#:GCC:_CO'
, PES.PROJECT_ID
, PPA.NAME PROJECTS_NAME
, PES.EXPENDITURE_ORGANIZATION_ID
, HOU1.NAME EXPENDITURE_ORGANIZATION_NAME
, PES.EXPENDITURE_TYPE
, PES.TASK_ID
, PT.TASK_NAME
, PES.AWARD_ID
, GAA.AWARD_FULL_NAME
, PES.SUMMARY_AMOUNT
, '_LA:DR_CR_FLAG:GL_LOOKUPS:DR_CR:MEANING'
, PES.GROUP_ID
, PES.INTERFACE_STATUS
, PES.PAYROLL_ID
, PAPF.PAYROLL_NAME
, PES.GL_PERIOD_ID
, PES.GL_PROJECT_FLAG
, PES.REJECT_REASON_CODE
, PES.ENC_CONTROL_ID
, PES.STATUS_CODE
, PES.LAST_UPDATE_DATE
, PES.LAST_UPDATED_BY
, PES.LAST_UPDATE_LOGIN
, PES.CREATED_BY
, PES.CREATION_DATE
FROM PSP_ENC_SUMMARY_LINES PES
, GL_CODE_COMBINATIONS GCC
, HR_ORGANIZATION_UNITS HOU
, HR_ORGANIZATION_UNITS HOU1
, GL_SETS_OF_BOOKS GL
, PER_TIME_PERIODS PTP
, PER_ALL_PEOPLE_F PPF
, PER_ALL_ASSIGNMENTS_F PAA
, PA_PROJECTS_ALL PPA
, PA_TASKS PT
, GMS_AWARDS_ALL GAA
, PAY_ALL_PAYROLLS_F PAPF
WHERE PES.BUSINESS_GROUP_ID = HOU.ORGANIZATION_ID
AND PES.SET_OF_BOOKS_ID = GL.SET_OF_BOOKS_ID
AND PES.PAYROLL_ID = PAPF.PAYROLL_ID
AND PES.EXPENDITURE_ORGANIZATION_ID = HOU1.ORGANIZATION_ID(+)
AND (PES.PERSON_ID = PPF.PERSON_ID
AND PES.EFFECTIVE_DATE BETWEEN PPF.EFFECTIVE_START_DATE
AND PPF.EFFECTIVE_END_DATE)
AND PES.TIME_PERIOD_ID = PTP.TIME_PERIOD_ID
AND (PES.ASSIGNMENT_ID = PAA.ASSIGNMENT_ID
AND PES.EFFECTIVE_DATE BETWEEN PAA.EFFECTIVE_START_DATE
AND PAA.EFFECTIVE_END_DATE)
AND PES.PROJECT_ID = PPA.PROJECT_ID(+)
AND PES.TASK_ID = PT.TASK_ID(+)
AND PES.AWARD_ID = GAA.AWARD_ID(+)
AND PES.GL_CODE_COMBINATION_ID = GCC.CODE_COMBINATION_ID(+) WITH READ ONLY