View: PSPFV_ENC_LINES_HISTORY

View Text

SELECT PEH.ENC_LINE_ID
, PEH.BUSINESS_GROUP_ID
, HOU.NAME BUSINESS_GRP_NAME
, PEH.SET_OF_BOOKS_ID
, GL.NAME SET_OF_BOOKS_NAME
, 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
, PPF.FIRST_NAME
, PPF.LAST_NAME
, PEH.ASSIGNMENT_ID
, PAA.ASSIGNMENT_NUMBER
, PEH.AWARD_ID
, GAA.AWARD_FULL_NAME
, PEH.TASK_ID
, PT.TASK_NAME
, PEH.EXPENDITURE_TYPE
, PEH.EXPENDITURE_ORGANIZATION_ID
, HOU1.NAME EXPENDITURE_ORGANIZATION_NAME
, PEH.PROJECT_ID
, PPA.NAME PROJECT_NAME
, '_KF:SQLGL:GL#:GCC:_CO'
, PEH.TIME_PERIOD_ID
, PTP.PERIOD_NAME
, PEH.PAYROLL_ID
, PAPF.PAYROLL_NAME
, 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
, HR_ORGANIZATION_UNITS HOU
, HR_ORGANIZATION_UNITS HOU1
, GL_SETS_OF_BOOKS GL
, PER_ALL_PEOPLE_F PPF
, PER_ALL_ASSIGNMENTS_F PAA
, GMS_AWARDS_ALL GAA
, PA_TASKS PT
, PA_PROJECTS_ALL PPA
, PER_TIME_PERIODS PTP
, PAY_ALL_PAYROLLS_F PAPF
WHERE PEH.BUSINESS_GROUP_ID = HOU.ORGANIZATION_ID
AND PEH.SET_OF_BOOKS_ID = GL.SET_OF_BOOKS_ID
AND PEH.PAYROLL_ID = PAPF.PAYROLL_ID
AND PEH.EXPENDITURE_ORGANIZATION_ID = HOU1.ORGANIZATION_ID(+)
AND (PEH.PERSON_ID = PPF.PERSON_ID
AND PEH.ENCUMBRANCE_DATE BETWEEN PPF.EFFECTIVE_START_DATE
AND PPF.EFFECTIVE_END_DATE)
AND PEH.TIME_PERIOD_ID = PTP.TIME_PERIOD_ID
AND (PEH.ASSIGNMENT_ID = PAA.ASSIGNMENT_ID
AND PEH.ENCUMBRANCE_DATE BETWEEN PAA.EFFECTIVE_START_DATE
AND PAA.EFFECTIVE_END_DATE)
AND PEH.PROJECT_ID = PPA.PROJECT_ID(+)
AND PEH.TASK_ID = PT.TASK_ID(+)
AND PEH.AWARD_ID = GAA.AWARD_ID(+)
AND PEH.GL_CODE_COMBINATION_ID = GCC.CODE_COMBINATION_ID(+) WITH READ ONLY

Columns