PSP Archive History

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Archive History Report
Application: Labor Distribution
Source: PSP: Archive History Report (XML)
Short Name: PSPARREP_XML
DB package: PSP_PSPARREP_XMLP_PKG
Run PSP Archive History and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT	DISTINCT
	PPF.payroll_name	payroll_name,
	PTP.start_date	start_date,
	PTP.end_date	end_date,
	PTP.period_name,
	'A'	func_area
FROM	PSP_PAYROLL_CONTROLS PPC,
	PER_TIME_PERIODS PTP,
	PAY_PAYROLLS_F	PPF
WHERE	PPC.payroll_id	=	PPF.payroll_id
and	PPC.time_period_id	 =	PTP.time_period_id
and	PPC.payroll_id	 =	nvl(:p_payroll_id,PPF.payroll_id)
and	PTP.time_period_id	>=	nvl(:p_begin_period,PTP.time_period_id)
and	PTP.time_period_id	<=	nvl(:p_end_period,PTP.time_period_id)
and	PPC.archive_flag	=	'Y'
UNION
SELECT	DISTINCT 
	PPF.payroll_name	payroll_name,
	PTP.start_date	start_date,
	PTP.end_date	end_date,
	PTP.period_name,
	'E'	func_area
FROM	PSP_ENC_CONTROLS PEC,
	PER_TIME_PERIODS PTP,
	PAY_PAYROLLS_F	PPF
WHERE	PEC.payroll_id	=	PPF.payroll_id
and	PEC.time_period_id	=	PTP.time_period_id
and	PEC.payroll_id	=	nvl(:p_payroll_id,PPF.payroll_id)
and	PTP.time_period_id	>=	nvl(:p_begin_period,PTP.time_period_id)
and	PTP.time_period_id	<=	nvl(:p_end_period,PTP.time_period_id)
and	PEC.archive_flag	=	'Y'
ORDER BY 1,2,5
Parameter Name SQL text Validation
Payroll Name 
 
 LOV Oracle
Begin Time Period 
 
 LOV Oracle
End Time Period 
 
 LOV Oracle
Download
 
Related Blitz Reports
PSP Encumbrance Suspense Charge PSP Organization Default Usage Encumbrance PSP Encumbrance History by Organization PSP Encumbrance process run results PSP Encumbrance History by Award PSP Distribution History by Organization PSP Encumbrance Liquidation Exception PSP Distribution History by Award PSP Distribution History by Project
Blitz Report™

Blitz Report™ provides multiple benefits: