PN Generate Portfolio Summary

➜ Back to Library
Description
Categories: BI Publisher
Columns: Run Date, Ou, As Of Date, Report Title, Representation, End Date, Legal Entity, Period End, Rep Status, Currency Code ...
Application: Property Manager
Source: Generate Portfolio Summary Report
Short Name: PNGPSR_XML
DB package: PN_LEASE_PORTFOLIO_REPORTS 
		SELECT TO_CHAR(SYSDATE,'DD-Mon-YYYY') RUN_DATE,
		hr_general.DECODE_ORGANIZATION(MO_GLOBAL.get_current_org_id) OU,
		TO_CHAR(:P_AS_OF_DATE,'DD-Mon-YYYY') AS_OF_DATE,
		'Generate Portfolio Summary Report' REPORT_TITLE,
		nvl(:P_REPRESENTATION, 'ALL') REPRESENTATION,
        TO_CHAR(:P_END_DATE, 'DD-Mon-YYYY') END_DATE,		
		(SELECT DISTINCT lep.name
			FROM xle_entity_profiles          lep
					,xle_registrations            reg
					,hr_locations_all             hrl
					,hz_parties                   hzp
					,fnd_territories_vl           ter
					,hr_operating_units           hro
					,hr_all_organization_units_tl hroutl_bg
					,hr_all_organization_units_tl hroutl_ou
					,hr_organization_units        gloperatingunitseo
		 WHERE lep.transacting_entity_flag = 'Y'
			 AND lep.party_id = hzp.party_id
			 AND lep.legal_entity_id = reg.source_id
			 AND reg.source_table = 'XLE_ENTITY_PROFILES'
			 AND hrl.location_id = reg.location_id
			 AND reg.identifying_flag = 'Y'
			 AND ter.territory_code = hrl.country
			 AND lep.legal_entity_id = hro.default_legal_context_id
			 AND gloperatingunitseo.organization_id = hro.organization_id
			 AND hroutl_bg.organization_id = hro.business_group_id
			 AND hroutl_ou.organization_id = hro.organization_id
			 AND hro.organization_id = MO_GLOBAL.get_current_org_id
			 AND hroutl_ou.language = userenv('LANG')) LEGAL_ENTITY,
			 TO_CHAR(:P_AS_OF_DATE,'DD-Mon-YYYY') PERIOD_END,
		Pn_Lease_Portfolio_Reports.Get_Report_Status(MO_GLOBAL.get_current_org_id,:P_AS_OF_DATE) REP_STATUS,
        PN_LEASE_PORTFOLIO_REPORTS.get_functional_currency(MO_GLOBAL.get_current_org_id) CURRENCY_CODE
		FROM DUAL
Parameter Name SQL text Validation
As Of Date 
 
 LOV Oracle
End Date 
 
 Date
Representation 
 
 LOV Oracle
Download
Related Blitz Reports
PN Generate Portfolio Detail ZX Party Tax Profiles XXSJ Report VAT Register RW - GL Ledgers and Organizations AR Customer Credit Limits AR Customers and Sites ONT Order Headers and Lines ONT DIFOT ONT Order Headers
Blitz Report In Action
Blitz Report™

Blitz Report™ provides multiple benefits: