VIEW: APPS.PSP_REP_DIST_PRJ_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')