Product: | PSP - Labor Distribution |
---|---|
Description: | PSPBV_ORG_SCHEDULE_LINES displays information about a charging account in a schedule that is used at the organization level. |
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
, PDL.BUSINESS_GROUP_ID
, PDL.COMMENTS
, PDL.ORGANIZATION_ID
, '_KF:SQLGL:GL#:GCC:_CO'
, PDL.PROJECT_ID
, PDL.TASK_ID
, PDL.AWARD_ID
, PDL.EXPENDITURE_ORGANIZATION_ID
, PDL.EXPENDITURE_TYPE
, PDL.LAST_UPDATE_DATE
, PDL.LAST_UPDATED_BY
, PDL.CREATED_BY
, PDL.CREATION_DATE
FROM PSP_DEFAULT_LABOR_SCHEDULES PDL
, GL_CODE_COMBINATIONS GCC
WHERE PDL.GL_CODE_COMBINATION_ID = GCC.CODE_COMBINATION_ID
AND '_SEC:PDL.EXPENDITURE_ORGANIZATION_ID' IS NOT NULL WITH READ ONLY