View: PSP_ADJUSTMENT_COMBO_V

Product:	PSP - Labor Distribution
Description:
Implementation/DBA Data:	APPS.PSP_ADJUSTMENT_COMBO_V

View Text

SELECT L.ASSIGNMENT_ID
, L.ELEMENT_TYPE_ID
, D.DISTRIBUTION_DATE
, D.BUSINESS_GROUP_ID
, D.SET_OF_BOOKS_ID
, 'DISTRIBUTION_LINES_HISTORY' SOURCE
FROM PSP_DISTRIBUTION_LINES_HISTORY D
, PSP_PAYROLL_SUB_LINES S
, PSP_PAYROLL_LINES L
WHERE D.PAYROLL_SUB_LINE_ID = S.PAYROLL_SUB_LINE_ID
AND S.PAYROLL_LINE_ID = L.PAYROLL_LINE_ID UNION SELECT ASSIGNMENT_ID
, ELEMENT_TYPE_ID
, DISTRIBUTION_DATE
, BUSINESS_GROUP_ID
, SET_OF_BOOKS_ID
, 'PRE_GEN_DIST_LINES_HISTORY'
FROM PSP_PRE_GEN_DIST_LINES_HISTORY UNION SELECT ASSIGNMENT_ID
, ELEMENT_TYPE_ID
, DISTRIBUTION_DATE
, BUSINESS_GROUP_ID
, SET_OF_BOOKS_ID
, 'ADJUSTMENT_LINES_HISTORY'
FROM PSP_ADJUSTMENT_LINES_HISTORY

Columns