View: PSP_REP_ENC_SSP_V

Product:	PSP - Labor Distribution
Description:	based on the PSP_ENC_LINES and HISTORY table used in the Encumbrance Suspense Report
Implementation/DBA Data:	APPS.PSP_REP_ENC_SSP_V

View Text

SELECT DISTINCT A.PAYROLL_ID
, A.TIME_PERIOD_ID
, A.PERSON_ID
, A.ASSIGNMENT_ID
, A.ENC_ELEMENT_TYPE_ID
, SUM(A.ENCUMBRANCE_AMOUNT)
, A.SUSPENSE_ORG_ACCOUNT_ID
, A.PROJECT_ID
, A.EXPENDITURE_ORGANIZATION_ID
, A.EXPENDITURE_TYPE
, A.TASK_ID
, A.AWARD_ID
, A.GL_CODE_COMBINATION_ID
, A.BUSINESS_GROUP_ID
, A.SET_OF_BOOKS_ID
FROM PSP_ENC_LINES A
WHERE A.SUSPENSE_ORG_ACCOUNT_ID IS NOT NULL
AND A.PAYROLL_ID IN (SELECT PAYROLL_ID
FROM PSP_ENC_CONTROLS
WHERE ACTION_CODE = 'N') GROUP BY A.BUSINESS_GROUP_ID
, A.SET_OF_BOOKS_ID
, A.PAYROLL_ID
, A.TIME_PERIOD_ID
, A.PERSON_ID
, A.ASSIGNMENT_ID
, A.ENC_ELEMENT_TYPE_ID
, A.SUSPENSE_ORG_ACCOUNT_ID
, A.PROJECT_ID
, A.EXPENDITURE_ORGANIZATION_ID
, A.EXPENDITURE_TYPE
, A.TASK_ID
, A.AWARD_ID
, A.GL_CODE_COMBINATION_ID UNION ALL SELECT DISTINCT B.PAYROLL_ID
, B.TIME_PERIOD_ID
, B.PERSON_ID
, B.ASSIGNMENT_ID
, B.ENC_ELEMENT_TYPE_ID
, SUM(B.ENCUMBRANCE_AMOUNT)
, B.SUSPENSE_ORG_ACCOUNT_ID
, B.PROJECT_ID
, B.EXPENDITURE_ORGANIZATION_ID
, B.EXPENDITURE_TYPE
, B.TASK_ID
, B.AWARD_ID
, B.GL_CODE_COMBINATION_ID
, B.BUSINESS_GROUP_ID
, B.SET_OF_BOOKS_ID
FROM PSP_ENC_LINES_HISTORY B
WHERE B.SUSPENSE_ORG_ACCOUNT_ID IS NOT NULL
AND B.PAYROLL_ID IN (SELECT PAYROLL_ID
FROM PSP_ENC_CONTROLS
WHERE ACTION_CODE = 'P') GROUP BY B.BUSINESS_GROUP_ID
, B.SET_OF_BOOKS_ID
, B.PAYROLL_ID
, B.TIME_PERIOD_ID
, B.PERSON_ID
, B.ASSIGNMENT_ID
, B.ENC_ELEMENT_TYPE_ID
, B.SUSPENSE_ORG_ACCOUNT_ID
, B.PROJECT_ID
, B.EXPENDITURE_ORGANIZATION_ID
, B.EXPENDITURE_TYPE
, B.TASK_ID
, B.AWARD_ID
, B.GL_CODE_COMBINATION_ID

Columns