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 ...
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
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 |