PN Generate Portfolio Summary

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

Copy

		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