Product: | PSP - Labor Distribution |
---|---|
Description: | PSPBV_GLOBAL_SCHEDULE_LINES displays information about the charging account to be used at the site level for the earnings element. |
Implementation/DBA Data: | Not implemented in this database |
SELECT PET.ELEMENT_ACCOUNT_ID
, PET.START_DATE_ACTIVE
, PET.END_DATE_ACTIVE
, PET.SET_OF_BOOKS_ID
, PET.PERCENT
, PET.COMMENTS
, PET.ELEMENT_TYPE_ID
, '_KF:SQLGL:GL#:GCC:_CO'
, PET.PROJECT_ID
, PET.TASK_ID
, PET.AWARD_ID
, PET.EXPENDITURE_ORGANIZATION_ID
, PET.EXPENDITURE_TYPE
, PET.LAST_UPDATE_DATE
, PET.LAST_UPDATED_BY
, PET.CREATED_BY
, PET.CREATION_DATE
FROM PSP_ELEMENT_TYPE_ACCOUNTS PET
, GL_CODE_COMBINATIONS GCC
WHERE PET.GL_CODE_COMBINATION_ID=GCC.CODE_COMBINATION_ID (+)
AND '_SEC:PET.EXPENDITURE_ORGANIZATION_ID' IS NOT NULL WITH READ ONLY