eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: PSPBV_GENERATED_DIST_HISTORIES

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

View Text

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

Columns

Name
DISTRIBUTION_LINE_ID
GL_OR_PROJECT
DEFAULT_ACCT_REASON_CODE
DISTRIBUTION_DATE
EFFECTIVE_DATE
DISTRIBUTION_AMOUNT
"_LA:STATUS_CODE"
SUSPENSE_ACCOUNT_REASON
"_LA:INCLUDE_IN_EFFORT_REPORT"
"_LA:REVERSAL_ENTRY_FLAG"
USER_DEFINED_FIELD
ADJUSTMENT_BATCH_NAME
SUMMARY_LINE_ID
EFFORT_REPORT_ID
VERSION_NUMBER
PAYROLL_SUB_LINE_ID
SET_OF_BOOKS_ID
BUSINESS_GROUP_ID