Product: | PSP - Labor Distribution |
---|---|
Description: | PSPBV_COST_DIST_SUM_LINES displays summarized information on distribution lines. This view reduces the number of lines posted in General Ledger and Grants Management systems. |
Implementation/DBA Data: | Not implemented in this database |
SELECT PSL.SUMMARY_LINE_ID
, PSL.GROUP_ID
, PSL.GMS_BATCH_NAME
, PSL.INTERFACE_STATUS
, '_LA:SOURCE_TYPE:PSP_LOOKUPS:PSP_SOURCE_TYPE:MEANING'
, PSL.SOURCE_CODE
, PSL.INTERFACE_BATCH_NAME
, PSL.EFFECTIVE_DATE
, PSL.SET_OF_BOOKS_ID
, PSL.BUSINESS_GROUP_ID
, PSL.SUMMARY_AMOUNT
, '_LA:DR_CR_FLAG:GL_LOOKUPS:DR_CR:MEANING'
, '_LA:STATUS_CODE:PSP_LOOKUPS:PSP_STATUS_CODE:MEANING'
, PSL.TIME_PERIOD_ID
, PSL.PAYROLL_CONTROL_ID
, PSL.ASSIGNMENT_ID
, '_KF:SQLGL:GL#:GCC:_CO'
, PSL.PROJECT_ID
, PSL.TASK_ID
, PSL.AWARD_ID
, PSL.EXPENDITURE_ORGANIZATION_ID
, PSL.EXPENDITURE_TYPE
, PSL.LAST_UPDATE_DATE
, PSL.LAST_UPDATED_BY
, PSL.CREATED_BY
, PSL.CREATION_DATE
FROM PSP_SUMMARY_LINES PSL
, GL_CODE_COMBINATIONS GCC
WHERE PSL.GL_CODE_COMBINATION_ID=GCC.CODE_COMBINATION_ID
AND '_SEC:PSL.EXPENDITURE_ORGANIZATION_ID' IS NOT NULL WITH READ ONLY