VIEW: PSP.PSP_ADJUSTMENT_LINES_ARCH#

Source

View Text - Preformatted

select ADJUSTMENT_LINE_ID ADJUSTMENT_LINE_ID, PERSON_ID PERSON_ID, ASSIGNMENT_ID ASSIGNMENT_ID, ELEMENT_TYPE_ID ELEMENT_TYPE_ID, DISTRIBUTION_DATE DISTRIBUTION_DATE, EFFECTIVE_DATE EFFECTIVE_DATE, DISTRIBUTION_AMOUNT DISTRIBUTION_AMOUNT, DR_CR_FLAG DR_CR_FLAG, PAYROLL_CONTROL_ID PAYROLL_CONTROL_ID, SOURCE_CODE SOURCE_CODE, TIME_PERIOD_ID TIME_PERIOD_ID, BATCH_NAME BATCH_NAME, STATUS_CODE STATUS_CODE, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, GL_CODE_COMBINATION_ID GL_CODE_COMBINATION_ID, PROJECT_ID PROJECT_ID, EXPENDITURE_ORGANIZATION_ID EXPENDITURE_ORGANIZATION_ID, EXPENDITURE_TYPE EXPENDITURE_TYPE, TASK_ID TASK_ID, AWARD_ID AWARD_ID, SUSPENSE_ORG_ACCOUNT_ID SUSPENSE_ORG_ACCOUNT_ID, SUSPENSE_REASON_CODE SUSPENSE_REASON_CODE, INCLUDE_IN_ER_FLAG INCLUDE_IN_ER_FLAG, EFFORT_REPORT_ID EFFORT_REPORT_ID, VERSION_NUM VERSION_NUM, SUMMARY_LINE_ID SUMMARY_LINE_ID, REVERSAL_ENTRY_FLAG REVERSAL_ENTRY_FLAG, ORIGINAL_LINE_FLAG ORIGINAL_LINE_FLAG, USER_DEFINED_FIELD USER_DEFINED_FIELD, ADJUSTMENT_BATCH_NAME ADJUSTMENT_BATCH_NAME, PERCENT PERCENT, ORIG_SOURCE_TYPE ORIG_SOURCE_TYPE, ORIG_LINE_ID ORIG_LINE_ID, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, 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, SOURCE_TYPE SOURCE_TYPE, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, ADJ_SET_NUMBER ADJ_SET_NUMBER, LINE_NUMBER LINE_NUMBER from "PSP"."PSP_ADJUSTMENT_LINES_ARCH"

View Text - HTML Formatted

SELECT ADJUSTMENT_LINE_ID ADJUSTMENT_LINE_ID
, PERSON_ID PERSON_ID
, ASSIGNMENT_ID ASSIGNMENT_ID
, ELEMENT_TYPE_ID ELEMENT_TYPE_ID
, DISTRIBUTION_DATE DISTRIBUTION_DATE
, EFFECTIVE_DATE EFFECTIVE_DATE
, DISTRIBUTION_AMOUNT DISTRIBUTION_AMOUNT
, DR_CR_FLAG DR_CR_FLAG
, PAYROLL_CONTROL_ID PAYROLL_CONTROL_ID
, SOURCE_CODE SOURCE_CODE
, TIME_PERIOD_ID TIME_PERIOD_ID
, BATCH_NAME BATCH_NAME
, STATUS_CODE STATUS_CODE
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, GL_CODE_COMBINATION_ID GL_CODE_COMBINATION_ID
, PROJECT_ID PROJECT_ID
, EXPENDITURE_ORGANIZATION_ID EXPENDITURE_ORGANIZATION_ID
, EXPENDITURE_TYPE EXPENDITURE_TYPE
, TASK_ID TASK_ID
, AWARD_ID AWARD_ID
, SUSPENSE_ORG_ACCOUNT_ID SUSPENSE_ORG_ACCOUNT_ID
, SUSPENSE_REASON_CODE SUSPENSE_REASON_CODE
, INCLUDE_IN_ER_FLAG INCLUDE_IN_ER_FLAG
, EFFORT_REPORT_ID EFFORT_REPORT_ID
, VERSION_NUM VERSION_NUM
, SUMMARY_LINE_ID SUMMARY_LINE_ID
, REVERSAL_ENTRY_FLAG REVERSAL_ENTRY_FLAG
, ORIGINAL_LINE_FLAG ORIGINAL_LINE_FLAG
, USER_DEFINED_FIELD USER_DEFINED_FIELD
, ADJUSTMENT_BATCH_NAME ADJUSTMENT_BATCH_NAME
, PERCENT PERCENT
, ORIG_SOURCE_TYPE ORIG_SOURCE_TYPE
, ORIG_LINE_ID ORIG_LINE_ID
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, 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
, SOURCE_TYPE SOURCE_TYPE
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, ADJ_SET_NUMBER ADJ_SET_NUMBER
, LINE_NUMBER LINE_NUMBER
FROM "PSP"."PSP_ADJUSTMENT_LINES_ARCH"