VIEW: PSP.PSP_DISTRIBUTION_LINES_ARCH#

Source

View Text - Preformatted

select DISTRIBUTION_LINE_ID DISTRIBUTION_LINE_ID, DISTRIBUTION_DATE DISTRIBUTION_DATE, EFFECTIVE_DATE EFFECTIVE_DATE, DISTRIBUTION_AMOUNT DISTRIBUTION_AMOUNT, STATUS_CODE STATUS_CODE, DEFAULT_REASON_CODE DEFAULT_REASON_CODE, SUSPENSE_REASON_CODE SUSPENSE_REASON_CODE, INCLUDE_IN_ER_FLAG INCLUDE_IN_ER_FLAG, EFFORT_REPORT_ID EFFORT_REPORT_ID, VERSION_NUM VERSION_NUM, SCHEDULE_LINE_ID SCHEDULE_LINE_ID, SUMMARY_LINE_ID SUMMARY_LINE_ID, DEFAULT_ORG_ACCOUNT_ID DEFAULT_ORG_ACCOUNT_ID, SUSPENSE_ORG_ACCOUNT_ID SUSPENSE_ORG_ACCOUNT_ID, ELEMENT_ACCOUNT_ID ELEMENT_ACCOUNT_ID, ORG_SCHEDULE_ID ORG_SCHEDULE_ID, GL_PROJECT_FLAG GL_PROJECT_FLAG, REVERSAL_ENTRY_FLAG REVERSAL_ENTRY_FLAG, USER_DEFINED_FIELD USER_DEFINED_FIELD, ADJUSTMENT_BATCH_NAME ADJUSTMENT_BATCH_NAME, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, PAYROLL_SUB_LINE_ID PAYROLL_SUB_LINE_ID, AUTO_EXPENDITURE_TYPE AUTO_EXPENDITURE_TYPE, AUTO_GL_CODE_COMBINATION_ID AUTO_GL_CODE_COMBINATION_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_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, CAP_EXCESS_DIST_LINE_ID CAP_EXCESS_DIST_LINE_ID, CAP_EXCESS_GLCCID CAP_EXCESS_GLCCID, CAP_EXCESS_AWARD_ID CAP_EXCESS_AWARD_ID, CAP_EXCESS_PROJECT_ID CAP_EXCESS_PROJECT_ID, CAP_EXCESS_TASK_ID CAP_EXCESS_TASK_ID, CAP_EXCESS_EXP_ORG_ID CAP_EXCESS_EXP_ORG_ID, CAP_EXCESS_EXP_TYPE CAP_EXCESS_EXP_TYPE, FUNDING_SOURCE_CODE FUNDING_SOURCE_CODE, ANNUAL_SALARY_CAP ANNUAL_SALARY_CAP, SUSPENSE_AUTO_GLCCID SUSPENSE_AUTO_GLCCID, SUSPENSE_AUTO_EXP_TYPE SUSPENSE_AUTO_EXP_TYPE, ADJ_ACCOUNT_FLAG ADJ_ACCOUNT_FLAG from "PSP"."PSP_DISTRIBUTION_LINES_ARCH"

View Text - HTML Formatted

SELECT DISTRIBUTION_LINE_ID DISTRIBUTION_LINE_ID
, DISTRIBUTION_DATE DISTRIBUTION_DATE
, EFFECTIVE_DATE EFFECTIVE_DATE
, DISTRIBUTION_AMOUNT DISTRIBUTION_AMOUNT
, STATUS_CODE STATUS_CODE
, DEFAULT_REASON_CODE DEFAULT_REASON_CODE
, SUSPENSE_REASON_CODE SUSPENSE_REASON_CODE
, INCLUDE_IN_ER_FLAG INCLUDE_IN_ER_FLAG
, EFFORT_REPORT_ID EFFORT_REPORT_ID
, VERSION_NUM VERSION_NUM
, SCHEDULE_LINE_ID SCHEDULE_LINE_ID
, SUMMARY_LINE_ID SUMMARY_LINE_ID
, DEFAULT_ORG_ACCOUNT_ID DEFAULT_ORG_ACCOUNT_ID
, SUSPENSE_ORG_ACCOUNT_ID SUSPENSE_ORG_ACCOUNT_ID
, ELEMENT_ACCOUNT_ID ELEMENT_ACCOUNT_ID
, ORG_SCHEDULE_ID ORG_SCHEDULE_ID
, GL_PROJECT_FLAG GL_PROJECT_FLAG
, REVERSAL_ENTRY_FLAG REVERSAL_ENTRY_FLAG
, USER_DEFINED_FIELD USER_DEFINED_FIELD
, ADJUSTMENT_BATCH_NAME ADJUSTMENT_BATCH_NAME
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, PAYROLL_SUB_LINE_ID PAYROLL_SUB_LINE_ID
, AUTO_EXPENDITURE_TYPE AUTO_EXPENDITURE_TYPE
, AUTO_GL_CODE_COMBINATION_ID AUTO_GL_CODE_COMBINATION_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_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
, CAP_EXCESS_DIST_LINE_ID CAP_EXCESS_DIST_LINE_ID
, CAP_EXCESS_GLCCID CAP_EXCESS_GLCCID
, CAP_EXCESS_AWARD_ID CAP_EXCESS_AWARD_ID
, CAP_EXCESS_PROJECT_ID CAP_EXCESS_PROJECT_ID
, CAP_EXCESS_TASK_ID CAP_EXCESS_TASK_ID
, CAP_EXCESS_EXP_ORG_ID CAP_EXCESS_EXP_ORG_ID
, CAP_EXCESS_EXP_TYPE CAP_EXCESS_EXP_TYPE
, FUNDING_SOURCE_CODE FUNDING_SOURCE_CODE
, ANNUAL_SALARY_CAP ANNUAL_SALARY_CAP
, SUSPENSE_AUTO_GLCCID SUSPENSE_AUTO_GLCCID
, SUSPENSE_AUTO_EXP_TYPE SUSPENSE_AUTO_EXP_TYPE
, ADJ_ACCOUNT_FLAG ADJ_ACCOUNT_FLAG
FROM "PSP"."PSP_DISTRIBUTION_LINES_ARCH"