Product: | PSP - Labor Distribution |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT PSL.SUMMARY_LINE_ID
, PSL.GROUP_ID
, PSL.GMS_BATCH_NAME
, PSL.INTERFACE_STATUS
, '_LA:PSL.SOURCE_TYPE:PSP_LOOKUPS:PSP_SOURCE_TYPE:MEANING'
, PSL.SOURCE_CODE
, PPS.DESCRIPTION
, PSL.INTERFACE_BATCH_NAME
, PSL.EFFECTIVE_DATE
, PSL.SET_OF_BOOKS_ID
, GSB.NAME
, PSL.BUSINESS_GROUP_ID
, HOU1.NAME
, PSL.SUMMARY_AMOUNT
, '_LA:PSL.DR_CR_FLAG:GL_LOOKUPS:DR_CR:MEANING'
, '_LA:PSL.STATUS_CODE:PSP_LOOKUPS:PSP_STATUS_CODE:MEANING'
, PSL.TIME_PERIOD_ID
, PTP.PERIOD_NAME
, PSL.PERSON_ID
, PSL.PAYROLL_CONTROL_ID
, PSL.ASSIGNMENT_ID
, PAA.ASSIGNMENT_NUMBER
, '_KF:SQLGL:GL#:GCC:_CO'
, PSL.PROJECT_ID
, PPA.NAME
, PSL.TASK_ID
, PT.TASK_NAME
, PSL.AWARD_ID
, GAA.AWARD_FULL_NAME
, PSL.EXPENDITURE_ORGANIZATION_ID
, HOU.NAME
, PSL.EXPENDITURE_TYPE
, PPC.BATCH_NAME
, '_LA:PPC.STATUS_CODE:PSP_LOOKUPS:PSP_STATUS_CODE:MEANING'
, PPF.EMPLOYEE_NUMBER
, PPF.FIRST_NAME
, PPF.LAST_NAME
, PTP.START_DATE
, PTP.END_DATE
, PTP.PERIOD_NAME
, PTP.PERIOD_TYPE
, PSL.LAST_UPDATE_DATE
, PSL.LAST_UPDATED_BY
, PSL.CREATED_BY
, PSL.CREATION_DATE
FROM PSP_SUMMARY_LINES PSL
, PSP_PAYROLL_CONTROLS PPC
, PER_ALL_PEOPLE_F PPF
, PER_TIME_PERIODS PTP
, PER_ALL_ASSIGNMENTS_F PAA
, PA_PROJECTS_ALL PPA
, PA_TASKS PT
, GMS_AWARDS_ALL GAA
, HR_ALL_ORGANIZATION_UNITS HOU
, GL_SETS_OF_BOOKS GSB
, PSP_PAYROLL_SOURCES PPS
, GL_CODE_COMBINATIONS GCC
, HR_ALL_ORGANIZATION_UNITS HOU1
WHERE PSL.PAYROLL_CONTROL_ID = PPC.PAYROLL_CONTROL_ID
AND (PSL.PERSON_ID = PPF.PERSON_ID
AND PSL.EFFECTIVE_DATE BETWEEN PPF.EFFECTIVE_START_DATE
AND PPF.EFFECTIVE_END_DATE)
AND PSL.TIME_PERIOD_ID = PTP.TIME_PERIOD_ID
AND (PSL.ASSIGNMENT_ID = PAA.ASSIGNMENT_ID
AND PSL.EFFECTIVE_DATE BETWEEN PAA.EFFECTIVE_START_DATE
AND PAA.EFFECTIVE_END_DATE)
AND PSL.PROJECT_ID = PPA.PROJECT_ID(+)
AND PSL.TASK_ID = PT.TASK_ID(+)
AND PSL.AWARD_ID = GAA.AWARD_ID(+)
AND PSL.EXPENDITURE_ORGANIZATION_ID = HOU.ORGANIZATION_ID(+)
AND PSL.SOURCE_CODE = PPS.SOURCE_CODE
AND PSL.SOURCE_TYPE=PPS.SOURCE_TYPE
AND PSL.SET_OF_BOOKS_ID = GSB.SET_OF_BOOKS_ID
AND PSL.BUSINESS_GROUP_ID = HOU1.ORGANIZATION_ID
AND PSL.GL_CODE_COMBINATION_ID = GCC.CODE_COMBINATION_ID(+)
AND '_SEC:PSL.EXPENDITURE_ORGANIZATION_ID' IS NOT NULL WITH READ ONLY