View: PSPFV_LABOR_SCHEDULE_LINES

View Text

SELECT PSL.SCHEDULE_LINE_ID
, PSL.SCHEDULE_BEGIN_DATE
, PSL.SCHEDULE_END_DATE
, PSL.SCHEDULE_PERCENT
, PSL.ENCUMBER_STATUS_CODE
, PSL.DEFAULT_FLAG
, PSL.WARNING_CODE
, PSL.SET_OF_BOOKS_ID
, GSB.NAME
, PSL.BUSINESS_GROUP_ID
, HOU2.NAME
, PSL.SCHEDULE_HIERARCHY_ID
, '_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
, PSL.LAST_UPDATE_DATE
, PSL.LAST_UPDATED_BY
, PSL.CREATED_BY
, PSL.CREATION_DATE
FROM PSP_SCHEDULE_LINES PSL
, GL_SETS_OF_BOOKS GSB
, PA_PROJECTS_ALL PPA
, PA_TASKS PT
, GMS_AWARDS_ALL GAA
, HR_ALL_ORGANIZATION_UNITS HOU
, GL_CODE_COMBINATIONS GCC
, HR_ALL_ORGANIZATION_UNITS HOU2
WHERE PSL.SET_OF_BOOKS_ID = GSB.SET_OF_BOOKS_ID(+)
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.GL_CODE_COMBINATION_ID = GCC.CODE_COMBINATION_ID(+)
AND PSL.BUSINESS_GROUP_ID= HOU.ORGANIZATION_ID
AND '_SEC:PSL.EXPENDITURE_ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns