VIEW: APPS.PSP_ADJUSTMENT_COMBO_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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