Product: | PSP - Labor Distribution |
---|---|
Description: | Shows summary lines and distribution lines that are for debit |
Implementation/DBA Data: | Not implemented in this database |
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 = 'D'
AND A.STATUS_CODE = 'A'
AND B.STATUS_CODE = 'A'