Product: | PSP - Labor Distribution |
---|---|
Description: | PSPBV_PREGEN_DIST_HISTORIES displays the distributed Oracle Payroll and non-Oracle payroll sublines that are transferred to General Ledger and Grants Management successfully. |
Implementation/DBA Data: | Not implemented in this database |
SELECT PPG.PRE_GEN_DIST_LINE_ID
, '_LA:DR_CR_FLAG:GL_LOOKUPS:DR_CR:MEANING'
, '_LA:SOURCE_TYPE:PSP_LOOKUPS:PSP_SOURCE_TYPE:MEANING'
, PPG.SOURCE_CODE
, PPG.BATCH_NAME
, PPG.SUSPENSE_ORG_ACCOUNT_ID
, PPG.DISTRIBUTION_DATE
, PPG.EFFECTIVE_DATE
, PPG. DISTRIBUTION_AMOUNT
, '_LA:STATUS_CODE:PSP_LOOKUPS:PSP_STATUS_CODE:MEANING'
, PPG.SUSPENSE_REASON_CODE
, '_LA:INCLUDE_IN_ER_FLAG:GL_LOOKUPS:YES/NO:MEANING'
, '_LA:REVERSAL_ENTRY_FLAG:GL_LOOKUPS:YES/NO:MEANING'
, PPG.USER_DEFINED_FIELD
, PPG.ADJUSTMENT_BATCH_NAME
, PPG.PERSON_ID
, PPG.ASSIGNMENT_ID
, PPG.ELEMENT_TYPE_ID
, PPG.PAYROLL_CONTROL_ID
, PPG.TIME_PERIOD_ID
, PPG.SET_OF_BOOKS_ID
, PPG.BUSINESS_GROUP_ID
, PPG.EFFORT_REPORT_ID
, PPG.VERSION_NUM
, PPG.SUMMARY_LINE_ID
, '_KF:SQLGL:GL#:GCC:_CO'
, PPG.PROJECT_ID
, PPG.TASK_ID
, PPG.AWARD_ID
, PPG.EXPENDITURE_ORGANIZATION_ID
, PPG.EXPENDITURE_TYPE
FROM PSP_PRE_GEN_DIST_LINES_HISTORY PPG
, GL_CODE_COMBINATIONS GCC
WHERE PPG.GL_CODE_COMBINATION_ID = GCC.CODE_COMBINATION_ID(+)
AND '_SEC:PPG.EXPENDITURE_ORGANIZATION_ID' IS NOT NULL WITH READ ONLY