Product: | PSP - Labor Distribution |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT PEH.ENC_LINE_ID
, PEH.BUSINESS_GROUP_ID
, PEH.SET_OF_BOOKS_ID
, PEH.ENC_ELEMENT_TYPE_ID
, PEH.ENCUMBRANCE_DATE
, '_LA:DR_CR_FLAG:GL_LOOKUPS:DR_CR:MEANING'
, PEH.ENCUMBRANCE_AMOUNT
, '_LA:ENC_LINE_TYPE:PSP_LOOKUPS:PSP_ENC_LINE_TYPES:MEANING'
, PEH.SCHEDULE_LINE_ID
, PEH.ORG_SCHEDULE_ID
, PEH.DEFAULT_ORG_ACCOUNT_ID
, PEH.SUSPENSE_ORG_ACCOUNT_ID
, PEH.ELEMENT_ACCOUNT_ID
, PEH.GL_PROJECT_FLAG
, PEH.ENC_SUMMARY_LINE_ID
, PEH.PERSON_ID
, PEH.ASSIGNMENT_ID
, PEH.AWARD_ID
, PEH.TASK_ID
, PEH.EXPENDITURE_TYPE
, PEH.EXPENDITURE_ORGANIZATION_ID
, PEH.PROJECT_ID
, '_KF:SQLGL:GL#:GCC:_CO'
, PEH.TIME_PERIOD_ID
, PEH.PAYROLL_ID
, PEH.DEFAULT_REASON_CODE
, PEH.SUSPENSE_REASON_CODE
, PEH.STATUS_CODE
, PEH.ENC_CONTROL_ID
, PEH.LAST_UPDATE_DATE
, PEH.LAST_UPDATED_BY
, PEH.LAST_UPDATE_LOGIN
, PEH.CREATED_BY
, PEH.CREATION_DATE
FROM PSP_ENC_LINES_HISTORY PEH
, GL_CODE_COMBINATIONS GCC
WHERE PEH.GL_CODE_COMBINATION_ID = GCC.CODE_COMBINATION_ID WITH READ ONLY