eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: PSP.PSP_TEMP_ORIG_LINES#

Source

View Text - Preformatted


select ACCT_GROUP_ID ACCT_GROUP_ID, ORIG_SOURCE_TYPE ORIG_SOURCE_TYPE, ORIG_LINE_ID ORIG_LINE_ID, ORIG_DISTRIBUTION_DATE ORIG_DISTRIBUTION_DATE, RUN_ID RUN_ID, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, EFFECTIVE_DATE EFFECTIVE_DATE, DISTRIBUTION_AMOUNT DISTRIBUTION_AMOUNT, DR_CR_FLAG DR_CR_FLAG, TIME_PERIOD_ID TIME_PERIOD_ID, PAYROLL_CONTROL_ID PAYROLL_CONTROL_ID, ELEMENT_TYPE_ID ELEMENT_TYPE_ID, ELEMENT_GROUP_ID ELEMENT_GROUP_ID, GL_CODE_COMBINATION_ID GL_CODE_COMBINATION_ID, PROJECT_ID PROJECT_ID, EXPENDITURE_ORGANIZATION_ID EXPENDITURE_ORGANIZATION_ID, TASK_ID TASK_ID, AWARD_ID AWARD_ID, EXPENDITURE_TYPE EXPENDITURE_TYPE, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10 from "PSP"."PSP_TEMP_ORIG_LINES"

View Text - HTML Formatted

SELECT ACCT_GROUP_ID ACCT_GROUP_ID
, ORIG_SOURCE_TYPE ORIG_SOURCE_TYPE
, ORIG_LINE_ID ORIG_LINE_ID
, ORIG_DISTRIBUTION_DATE ORIG_DISTRIBUTION_DATE
, RUN_ID RUN_ID
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, EFFECTIVE_DATE EFFECTIVE_DATE
, DISTRIBUTION_AMOUNT DISTRIBUTION_AMOUNT
, DR_CR_FLAG DR_CR_FLAG
, TIME_PERIOD_ID TIME_PERIOD_ID
, PAYROLL_CONTROL_ID PAYROLL_CONTROL_ID
, ELEMENT_TYPE_ID ELEMENT_TYPE_ID
, ELEMENT_GROUP_ID ELEMENT_GROUP_ID
, GL_CODE_COMBINATION_ID GL_CODE_COMBINATION_ID
, PROJECT_ID PROJECT_ID
, EXPENDITURE_ORGANIZATION_ID EXPENDITURE_ORGANIZATION_ID
, TASK_ID TASK_ID
, AWARD_ID AWARD_ID
, EXPENDITURE_TYPE EXPENDITURE_TYPE
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
FROM "PSP"."PSP_TEMP_ORIG_LINES"