Product: | PSP - Labor Distribution |
---|---|
Description: | PSPBV_GENERATED_DIST_HISTORIES displays the distributed Oracle Payroll and non-Oracle payroll sublines that are successfully transferred to General Ledger and Grants Management. |
Implementation/DBA Data: | Not implemented in this database |
SELECT PDL.DISTRIBUTION_LINE_ID
, PDL.GL_PROJECT_FLAG
, PDL.DEFAULT_REASON_CODE
, PDL.DISTRIBUTION_DATE
, PDL.EFFECTIVE_DATE
, PDL.DISTRIBUTION_AMOUNT
, '_LA:STATUS_CODE:PSP_LOOKUPS:PSP_STATUS_CODE:MEANING'
, PDL.SUSPENSE_REASON_CODE
, '_LA:INCLUDE_IN_ER_FLAG:GL_LOOKUPS:YES/NO:MEANING'
, '_LA:REVERSAL_ENTRY_FLAG:GL_LOOKUPS:YES/NO:MEANING'
, PDL.USER_DEFINED_FIELD
, PDL.ADJUSTMENT_BATCH_NAME
, PDL.SUMMARY_LINE_ID
, PDL.EFFORT_REPORT_ID
, PDL.VERSION_NUM
, PDL.PAYROLL_SUB_LINE_ID
, PDL.SET_OF_BOOKS_ID
, PDL.BUSINESS_GROUP_ID
FROM PSP_DISTRIBUTION_LINES_HISTORY PDL WITH READ ONLY