[Home] [Help]
View: PSP_SUMMARY_LINES_C_V
Product: | PSP - Labor Distribution |
Description: | Shows summary lines that are for credit |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT SUMMARY_LINE_ID
, PERSON_ID
, ASSIGNMENT_ID
, SOURCE_CODE
, SOURCE_TYPE
, TIME_PERIOD_ID
, INTERFACE_BATCH_NAME BATCH_NAME
, SUMMARY_AMOUNT
, GL_CODE_COMBINATION_ID
, PROJECT_ID
, EXPENDITURE_ORGANIZATION_ID
, EXPENDITURE_TYPE
, TASK_ID
, AWARD_ID
, BUSINESS_GROUP_ID
, SET_OF_BOOKS_ID
FROM PSP_SUMMARY_LINES A
WHERE A.DR_CR_FLAG = 'C'
AND A.STATUS_CODE = 'A'
Columns
Name |
SUMMARY_LINE_ID |
PERSON_ID |
ASSIGNMENT_ID |
SOURCE_CODE |
SOURCE_TYPE |
TIME_PERIOD_ID |
BATCH_NAME |
SUMMARY_AMOUNT |
GL_CODE_COMBINATION_ID |
PROJECT_ID |
EXPENDITURE_ORGANIZATION_ID |
EXPENDITURE_TYPE |
TASK_ID |
AWARD_ID |
BUSINESS_GROUP_ID |
SET_OF_BOOKS_ID |