Product: | PSP - Labor Distribution |
---|---|
Description: | PSPBV_LABOR_SCHEDULE_LINES displays schedule information or charging instructions for different employees, assignments, element types, and orgs. |
Implementation/DBA Data: | Not implemented in this database |
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
, PSL.SCHEDULE_HIERARCHY_ID
, '_KF:SQLGL:GL#:GCC:_CO'
, PSL.PROJECT_ID
, PSL.TASK_ID
, PSL.AWARD_ID
, PSL.EXPENDITURE_ORGANIZATION_ID
, PSL.EXPENDITURE_TYPE
, PSL.BUSINESS_GROUP_ID
, PSL.LAST_UPDATE_DATE
, PSL.LAST_UPDATED_BY
, PSL.CREATED_BY
, PSL.CREATION_DATE
FROM PSP_SCHEDULE_LINES PSL
, GL_CODE_COMBINATIONS GCC
WHERE PSL.GL_CODE_COMBINATION_ID = GCC.CODE_COMBINATION_ID
AND '_SEC:PSL.EXPENDITURE_ORGANIZATION_ID' IS NOT NULL WITH READ ONLY