VIEW: PSP.PSP_ENC_LINES_HISTORY#

Source

View Text - Preformatted

select ENC_LINE_ID ENC_LINE_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, ENC_ELEMENT_TYPE_ID ENC_ELEMENT_TYPE_ID, ENCUMBRANCE_DATE ENCUMBRANCE_DATE, DR_CR_FLAG DR_CR_FLAG, ENCUMBRANCE_AMOUNT ENCUMBRANCE_AMOUNT, ENC_LINE_TYPE ENC_LINE_TYPE, SCHEDULE_LINE_ID SCHEDULE_LINE_ID, ORG_SCHEDULE_ID ORG_SCHEDULE_ID, DEFAULT_ORG_ACCOUNT_ID DEFAULT_ORG_ACCOUNT_ID, SUSPENSE_ORG_ACCOUNT_ID SUSPENSE_ORG_ACCOUNT_ID, ELEMENT_ACCOUNT_ID ELEMENT_ACCOUNT_ID, GL_PROJECT_FLAG GL_PROJECT_FLAG, ENC_SUMMARY_LINE_ID ENC_SUMMARY_LINE_ID, PERSON_ID PERSON_ID, ASSIGNMENT_ID ASSIGNMENT_ID, AWARD_ID AWARD_ID, TASK_ID TASK_ID, EXPENDITURE_TYPE EXPENDITURE_TYPE, EXPENDITURE_ORGANIZATION_ID EXPENDITURE_ORGANIZATION_ID, PROJECT_ID PROJECT_ID, GL_CODE_COMBINATION_ID GL_CODE_COMBINATION_ID, TIME_PERIOD_ID TIME_PERIOD_ID, PAYROLL_ID PAYROLL_ID, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, DEFAULT_REASON_CODE DEFAULT_REASON_CODE, SUSPENSE_REASON_CODE SUSPENSE_REASON_CODE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, STATUS_CODE STATUS_CODE, ENC_CONTROL_ID ENC_CONTROL_ID, CHANGE_FLAG CHANGE_FLAG, ENC_START_DATE ENC_START_DATE, ENC_END_DATE ENC_END_DATE, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, PAYROLL_ACTION_ID PAYROLL_ACTION_ID, ORIG_GL_CODE_COMBINATION_ID ORIG_GL_CODE_COMBINATION_ID, ORIG_PROJECT_ID ORIG_PROJECT_ID, ORIG_TASK_ID ORIG_TASK_ID, ORIG_AWARD_ID ORIG_AWARD_ID, ORIG_EXPENDITURE_ORG_ID ORIG_EXPENDITURE_ORG_ID, ORIG_EXPENDITURE_TYPE ORIG_EXPENDITURE_TYPE, HIERARCHY_CODE HIERARCHY_CODE, HIERARCHY_START_DATE HIERARCHY_START_DATE, HIERARCHY_END_DATE HIERARCHY_END_DATE from "PSP"."PSP_ENC_LINES_HISTORY"

View Text - HTML Formatted

SELECT ENC_LINE_ID ENC_LINE_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, ENC_ELEMENT_TYPE_ID ENC_ELEMENT_TYPE_ID
, ENCUMBRANCE_DATE ENCUMBRANCE_DATE
, DR_CR_FLAG DR_CR_FLAG
, ENCUMBRANCE_AMOUNT ENCUMBRANCE_AMOUNT
, ENC_LINE_TYPE ENC_LINE_TYPE
, SCHEDULE_LINE_ID SCHEDULE_LINE_ID
, ORG_SCHEDULE_ID ORG_SCHEDULE_ID
, DEFAULT_ORG_ACCOUNT_ID DEFAULT_ORG_ACCOUNT_ID
, SUSPENSE_ORG_ACCOUNT_ID SUSPENSE_ORG_ACCOUNT_ID
, ELEMENT_ACCOUNT_ID ELEMENT_ACCOUNT_ID
, GL_PROJECT_FLAG GL_PROJECT_FLAG
, ENC_SUMMARY_LINE_ID ENC_SUMMARY_LINE_ID
, PERSON_ID PERSON_ID
, ASSIGNMENT_ID ASSIGNMENT_ID
, AWARD_ID AWARD_ID
, TASK_ID TASK_ID
, EXPENDITURE_TYPE EXPENDITURE_TYPE
, EXPENDITURE_ORGANIZATION_ID EXPENDITURE_ORGANIZATION_ID
, PROJECT_ID PROJECT_ID
, GL_CODE_COMBINATION_ID GL_CODE_COMBINATION_ID
, TIME_PERIOD_ID TIME_PERIOD_ID
, PAYROLL_ID PAYROLL_ID
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, DEFAULT_REASON_CODE DEFAULT_REASON_CODE
, SUSPENSE_REASON_CODE SUSPENSE_REASON_CODE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, STATUS_CODE STATUS_CODE
, ENC_CONTROL_ID ENC_CONTROL_ID
, CHANGE_FLAG CHANGE_FLAG
, ENC_START_DATE ENC_START_DATE
, ENC_END_DATE ENC_END_DATE
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, PAYROLL_ACTION_ID PAYROLL_ACTION_ID
, ORIG_GL_CODE_COMBINATION_ID ORIG_GL_CODE_COMBINATION_ID
, ORIG_PROJECT_ID ORIG_PROJECT_ID
, ORIG_TASK_ID ORIG_TASK_ID
, ORIG_AWARD_ID ORIG_AWARD_ID
, ORIG_EXPENDITURE_ORG_ID ORIG_EXPENDITURE_ORG_ID
, ORIG_EXPENDITURE_TYPE ORIG_EXPENDITURE_TYPE
, HIERARCHY_CODE HIERARCHY_CODE
, HIERARCHY_START_DATE HIERARCHY_START_DATE
, HIERARCHY_END_DATE HIERARCHY_END_DATE
FROM "PSP"."PSP_ENC_LINES_HISTORY"