View: PSP_REP_DIST_PRJ_V

Product:	PSP - Labor Distribution
Description:	Based on the PSP_DISTRIBUTION_LINES_HISTORY table
Implementation/DBA Data:	APPS.PSP_REP_DIST_PRJ_V

View Text

SELECT A.PERSON_ID
, A.ASSIGNMENT_ID
, B.ELEMENT_TYPE_ID
, A.TIME_PERIOD_ID
, D.DISTRIBUTION_AMOUNT
, D.DISTRIBUTION_DATE
, A.PROJECT_ID
, A.AWARD_ID
, A.EXPENDITURE_TYPE
, A.BUSINESS_GROUP_ID
, A.SET_OF_BOOKS_ID
, A.DR_CR_FLAG
, PPC.CURRENCY_CODE
FROM PSP_SUMMARY_LINES A
, PSP_PAYROLL_LINES B
, PSP_PAYROLL_SUB_LINES C
, PSP_DISTRIBUTION_LINES_HISTORY D
, PSP_PAYROLL_CONTROLS PPC
WHERE B.PAYROLL_LINE_ID = C.PAYROLL_LINE_ID
AND C.PAYROLL_SUB_LINE_ID = D.PAYROLL_SUB_LINE_ID
AND A.SUMMARY_LINE_ID = D.SUMMARY_LINE_ID
AND PPC.PAYROLL_CONTROL_ID = B.PAYROLL_CONTROL_ID
AND D.GL_PROJECT_FLAG = 'P'
AND NOT EXISTS( SELECT 1 FROM PSP_ADJUSTMENT_LINES_HISTORY PDLH WHERE PDLH.ORIG_LINE_ID = D.DISTRIBUTION_LINE_ID AND PDLH.ORIGINAL_LINE_FLAG ='Y' AND PDLH.ORIG_SOURCE_TYPE = 'D')

Columns