PN Generate Portfolio Detail

Description
Categories: BI Publisher
Application: Property Manager
Source: Generate Portfolio Detail Report
Short Name: PNGPDR_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,
                   nvl(:P_REPRESENTATION, 'ALL') REPRESENTATION,
                   (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,
                     Pn_Lease_Portfolio_Reports.Get_Report_Status(MO_GLOBAL.get_current_org_id,:P_AS_OF_DATE) REPORT_STATUS,
                     TO_CHAR(:P_AS_OF_DATE,'DD-Mon-YYYY') PERIOD_END,
                     PN_LEASE_PORTFOLIO_REPORTS.get_functional_currency(MO_GLOBAL.get_current_org_id) CURRENCY_CODE
              FROM DUAL
Parameter Name SQL text Validation
Representation
 
LOV Oracle
As of Date
 
LOV Oracle