Query to derive Basic Information for Oracle PN (Property Management) Leases

SELECT lease.lease_num lease_number,
       lease.NAME lease_name,
       lease.lease_class_code,
       hou.NAME operating_unit,
       tower.location_code site_number,
       tower.building site_name,
       lease.lease_type_code,
       lease.lease_status,
       lease.status,
       detail.lease_execution_date execution_date,
       detail.lease_commencement_date commencement_date,
       detail.lease_termination_date termination_date,
       tower.lease_or_owned,
       tower.CLASS,
       address.county,
       address.state,
       address.country,
       address.zip_code
  FROM pn.pn_leases_all lease,
       pn.pn_lease_details_all detail,
       apps.hr_operating_units hou,
       apps.pn_tenancies_all tenancies,
       apps.pn_locations_all locations,
       apps.pn_locations_all tower,
       apps.pn_addresses_all address
 WHERE     1 = 1
       AND lease.lease_id = detail.lease_id
       AND tenancies.primary_flag(+) = 'Y'
       AND lease.org_id = hou.organization_id
       AND lease.lease_id = tenancies.lease_id
       AND tenancies.location_id = locations.location_id
       AND locations.PARENT_LOCATION_ID = tower.location_id
       AND tower.address_id = address.address_id