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_SUMMARY_DISTRIB_C_V

Product:	PSP - Labor Distribution
Description:	Shows summary lines and distribution lines that are for credit
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT A.SUMMARY_LINE_ID
, B.DISTRIBUTION_LINE_ID
, A.PERSON_ID
, A.ASSIGNMENT_ID
, A.GL_CODE_COMBINATION_ID
, A.PROJECT_ID
, A.EXPENDITURE_ORGANIZATION_ID
, A.EXPENDITURE_TYPE
, A.TASK_ID
, A.AWARD_ID
, A.SOURCE_CODE
, A.SOURCE_TYPE
, A.TIME_PERIOD_ID
, A.INTERFACE_BATCH_NAME BATCH_NAME
, A.SUMMARY_AMOUNT
, B.DISTRIBUTION_AMOUNT
, A.BUSINESS_GROUP_ID
, A.SET_OF_BOOKS_ID
FROM PSP_SUMMARY_LINES A
, PSP_DISTRIBUTION_LINES_HISTORY B
WHERE A.SUMMARY_LINE_ID = B.SUMMARY_LINE_ID
AND A.DR_CR_FLAG = 'C'
AND A.STATUS_CODE = 'A'
AND B.STATUS_CODE = 'A'

Columns

Name
SUMMARY_LINE_ID
DISTRIBUTION_LINE_ID
PERSON_ID
ASSIGNMENT_ID
GL_CODE_COMBINATION_ID
PROJECT_ID
EXPENDITURE_ORGANIZATION_ID
EXPENDITURE_TYPE
TASK_ID
AWARD_ID
SOURCE_CODE
SOURCE_TYPE
TIME_PERIOD_ID
BATCH_NAME
SUMMARY_AMOUNT
DISTRIBUTION_AMOUNT
BUSINESS_GROUP_ID
SET_OF_BOOKS_ID