PN Generate Portfolio Summary

		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

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