[Home] [Help]
| Product: | PSP - Labor Distribution |
|---|---|
| Description: | PSPBV_DIST_ADJUST_HISTORIES displays the adjusted lines that are transferred to General Ledger or Grants Management successfully. |
| Implementation/DBA Data: | Not implemented in this database |
SELECT PAL.ADJUSTMENT_LINE_ID
, '_LA:DR_CR_FLAG:GL_LOOKUPS:DR_CR:MEANING'
, '_LA:SOURCE_TYPE:PSP_LOOKUPS:PSP_SOURCE_TYPE:MEANING'
, PAL.SOURCE_CODE
, PAL.SET_OF_BOOKS_ID
, PAL.BUSINESS_GROUP_ID
, PAL.PERCENT
, PAL.ORIG_SOURCE_TYPE
, PAL.ORIG_LINE_ID
, PAL.ORIGINAL_LINE_FLAG
, PAL.DISTRIBUTION_DATE
, PAL.EFFECTIVE_DATE
, PAL.DISTRIBUTION_AMOUNT
, '_LA:STATUS_CODE:PSP_LOOKUPS:PSP_STATUS_CODE:MEANING'
, PAL.SUSPENSE_REASON_CODE
, '_LA:INCLUDE_IN_ER_FLAG:GL_LOOKUPS:YES/NO:MEANING'
, '_LA:REVERSAL_ENTRY_FLAG:GL_LOOKUPS:YES/NO:MEANING'
, PAL.USER_DEFINED_FIELD
, PAL.BATCH_NAME
, PAL.SUMMARY_LINE_ID
, PAL.EFFORT_REPORT_ID
, PAL.VERSION_NUM
, '_KF:SQLGL:GL#:GCC:_CO'
, PAL.PROJECT_ID
, PAL.TASK_ID
, PAL.AWARD_ID
, PAL.EXPENDITURE_ORGANIZATION_ID
, PAL.EXPENDITURE_TYPE
, PAL.ASSIGNMENT_ID
, PAL.ELEMENT_TYPE_ID
, PAL.PAYROLL_CONTROL_ID
, PAL.TIME_PERIOD_ID
, PAL.LAST_UPDATE_DATE
, PAL.LAST_UPDATED_BY
, PAL.CREATED_BY
, PAL.CREATION_DATE
FROM PSP_ADJUSTMENT_LINES_HISTORY PAL
, GL_CODE_COMBINATIONS GCC
WHERE PAL.GL_CODE_COMBINATION_ID=GCC.CODE_COMBINATION_ID
AND '_SEC:PAL.EXPENDITURE_ORGANIZATION_ID' IS NOT NULL WITH READ ONLY