Product: | PSP - Labor Distribution |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT PDL.ORG_SCHEDULE_ID
, PDL.SCHEDULE_BEGIN_DATE
, PDL.SCHEDULE_END_DATE
, PDL.SCHEDULE_PERCENT
, PDL.SET_OF_BOOKS_ID
, GSB.SET_OF_BOOKS_ID
, PDL.BUSINESS_GROUP_ID
, HOU2.NAME
, PDL.COMMENTS
, PDL.ORGANIZATION_ID
, '_KF:SQLGL:GL#:GCC:_CO'
, PDL.PROJECT_ID
, PPA.NAME
, PDL.TASK_ID
, PT.TASK_NAME
, PDL.AWARD_ID
, GAA.AWARD_FULL_NAME
, PDL.EXPENDITURE_ORGANIZATION_ID
, PDL.EXPENDITURE_TYPE
, PDL.LAST_UPDATE_DATE
, PDL.LAST_UPDATED_BY
, PDL.CREATED_BY
, PDL.CREATION_DATE
, HOU.NAME
FROM PSP_DEFAULT_LABOR_SCHEDULES PDL
, GL_CODE_COMBINATIONS GCC
, HR_ORGANIZATION_UNITS HOU
, GL_SETS_OF_BOOKS GSB
, PA_PROJECTS_ALL PPA
, PA_TASKS PT
, GMS_AWARDS_ALL GAA
, HR_ALL_ORGANIZATION_UNITS HOU2
WHERE PDL.EXPENDITURE_ORGANIZATION_ID = HOU.ORGANIZATION_ID(+)
AND PDL.GL_CODE_COMBINATION_ID=GCC.CODE_COMBINATION_ID(+)
AND PDL.SET_OF_BOOKS_ID = GSB.SET_OF_BOOKS_ID(+)
AND PDL.PROJECT_ID = PPA.PROJECT_ID(+)
AND PDL.TASK_ID = PT.TASK_ID(+)
AND PDL.AWARD_ID = GAA.AWARD_ID(+)
AND PDL.BUSINESS_GROUP_ID=HOU2.ORGANIZATION_ID
AND '_SEC:PDL.EXPENDITURE_ORGANIZATION_ID' IS NOT NULL WITH READ ONLY