VIEW: APPS.PSP_ORIG_LINE_DETAILS_V

Source

View Text - Preformatted

SELECT ptol.run_id, ptol.acct_group_id, psp_general.get_element_name(ptol.element_type_id) element_name, ppx.payroll_name, ptp.period_name, pps.source_code source_type, SUM(DECODE(ptol.dr_cr_flag, 'D', ptol.DISTRIBUTION_AMOUNT, (-1 * ptol.DISTRIBUTION_AMOUNT))) AMOUNT FROM psp_temp_orig_lines ptol, pay_payrolls_x ppx, per_time_periods ptp, psp_payroll_controls ppc, psp_payroll_sources pps WHERE ppx.payroll_id = ptp.payroll_id AND ptp.time_period_id = ptol.time_period_id AND ppc.payroll_control_id = ptol.payroll_control_id AND ppc.source_type = pps.source_type AND ppc.payroll_source_code = pps.source_code GROUP BY ptol.run_id, ptol.acct_group_id, psp_general.get_element_name(ptol.element_type_id), ppx.payroll_name, ptp.period_name, pps.source_code

View Text - HTML Formatted

SELECT PTOL.RUN_ID
, PTOL.ACCT_GROUP_ID
, PSP_GENERAL.GET_ELEMENT_NAME(PTOL.ELEMENT_TYPE_ID) ELEMENT_NAME
, PPX.PAYROLL_NAME
, PTP.PERIOD_NAME
, PPS.SOURCE_CODE SOURCE_TYPE
, SUM(DECODE(PTOL.DR_CR_FLAG
, 'D'
, PTOL.DISTRIBUTION_AMOUNT
, (-1 * PTOL.DISTRIBUTION_AMOUNT))) AMOUNT
FROM PSP_TEMP_ORIG_LINES PTOL
, PAY_PAYROLLS_X PPX
, PER_TIME_PERIODS PTP
, PSP_PAYROLL_CONTROLS PPC
, PSP_PAYROLL_SOURCES PPS
WHERE PPX.PAYROLL_ID = PTP.PAYROLL_ID
AND PTP.TIME_PERIOD_ID = PTOL.TIME_PERIOD_ID
AND PPC.PAYROLL_CONTROL_ID = PTOL.PAYROLL_CONTROL_ID
AND PPC.SOURCE_TYPE = PPS.SOURCE_TYPE
AND PPC.PAYROLL_SOURCE_CODE = PPS.SOURCE_CODE GROUP BY PTOL.RUN_ID
, PTOL.ACCT_GROUP_ID
, PSP_GENERAL.GET_ELEMENT_NAME(PTOL.ELEMENT_TYPE_ID)
, PPX.PAYROLL_NAME
, PTP.PERIOD_NAME
, PPS.SOURCE_CODE