eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.PN_LOCATIONS_V

Source

View Text - Preformatted


SELECT bld.rowid row_id, bld.org_id org_id, bld.location_id location_id, bld.location_code location_code, bld.location_alias location_alias, bld.building location_name, prop.property_id property_id, prop.property_name property_name, bld.location_id building_id, bld.building building, bld.location_code building_location_code, TO_NUMBER(NULL) floor_id, NULL floor, NULL floor_loction_code, TO_NUMBER(NULL) office_id, NULL office, NULL office_loction_code, NULL office_common_area_flag, bld.last_update_date last_update_date, bld.last_updated_by last_updated_by, bld.creation_date creation_date, bld.created_by created_by, bld.last_update_login last_update_login, bld.location_park_id location_park_id, bld.location_type_lookup_code location_type_lookup_code, bld.lease_or_owned lease_or_owned, loot.meaning lease_or_owned_tenure, bld.max_capacity max_capacity, bld.optimum_capacity optimum_capacity, bld.rentable_area rentable_area, bld.usable_area usable_area, bld.max_capacity building_max_capacity, bld.optimum_capacity building_optimum_capacity, bld.rentable_area building_rentable_area, bld.usable_area building_usable_area, TO_NUMBER(NULL) floor_max_capacity, TO_NUMBER(NULL) floor_optimum_capacity, TO_NUMBER(NULL) floor_rentable_area, TO_NUMBER(NULL) floor_usable_area, bld.uom_code uom_code, bld.status status, bld.attribute_category attribute_category, bld.attribute1 attribute1, bld.attribute2 attribute2, bld.attribute3 attribute3, bld.attribute4 attribute4, bld.attribute5 attribute5, bld.attribute6 attribute6, bld.attribute7 attribute7, bld.attribute8 attribute8, bld.attribute9 attribute9, bld.attribute10 attribute10, bld.attribute11 attribute11, bld.attribute12 attribute12, bld.attribute13 attribute13, bld.attribute14 attribute14, bld.attribute15 attribute15, uom.unit_of_measure unit_of_measure, bld.address_id address_id, addr.address_line1 address_line1, addr.address_line2 address_line2, addr.address_line3 address_line3, addr.address_line4 address_line4, addr.county county, addr.city city, addr.state state, addr.province province, addr.zip_code zip_code, addr.country country, terr.address_style address_style, addr.territory_id territory_id, addr.addr_attribute_category addr_attribute_category, addr.addr_attribute1 addr_attribute1, addr.addr_attribute2 addr_attribute2, addr.addr_attribute3 addr_attribute3, addr.addr_attribute4 addr_attribute4, addr.addr_attribute5 addr_attribute5, addr.addr_attribute6 addr_attribute6, addr.addr_attribute7 addr_attribute7, addr.addr_attribute8 addr_attribute8, addr.addr_attribute9 addr_attribute9, addr.addr_attribute10 addr_attribute10, addr.addr_attribute11 addr_attribute11, addr.addr_attribute12 addr_attribute12, addr.addr_attribute13 addr_attribute13, addr.addr_attribute14 addr_attribute14, addr.addr_attribute15 addr_attribute15, terr.territory_short_name territory_short_name, pnp_util_func.get_concatenated_address(addr.address_style, addr.address_line1, addr.address_line2, addr.address_line3, addr.address_line4, addr.city, addr.county, addr.state, addr.province, addr.zip_code, terr.territory_short_name ) concatenated_address, flv.meaning location_type, DECODE(plp1.location_park_type, 'OFFPRK', plp1.location_park_id, NULL) office_park_id, DECODE(plp1.location_park_type, 'OFFPRK', plp1.name, NULL) office_park_name, DECODE(plp1.location_park_type, 'REGION', plp1.location_park_id, plp2.location_park_id) region_id, DECODE(plp1.location_park_type, 'REGION', plp1.name, plp2.name) region_name, bld.active_start_date active_start_date, TO_DATE(DECODE(TO_CHAR(bld.active_end_date,'MM/DD/YYYY'),'12/31/4712', NULL,TO_CHAR(bld.active_end_date,'MM/DD/YYYY')),'MM/DD/YYYY') active_end_date, NVL(bld.occupancy_status_code,'Y') occupancy_status_code, ocst.meaning occupancy_status, NVL(bld.assignable_emp,'Y') assignable_emp, NVL(bld.assignable_cc,'Y') assignable_cc, NVL(bld.assignable_cust,'Y') assignable_cust, bld.disposition_code, LTRIM(RTRIM(disp.meaning)) disposition, bld.acc_treatment_code, LTRIM(RTRIM(acct.meaning)) acc_treatment FROM mtl_units_of_measure uom, pn_addresses_all addr, fnd_territories_vl terr, pn_location_parks plp1, pn_location_parks plp2, pn_properties_all prop, fnd_lookups flv, fnd_lookups loot, fnd_lookups ocst, fnd_lookups disp, fnd_lookups acct, pn_locations bld WHERE bld.location_type_lookup_code IN ('BUILDING','LAND') AND uom.uom_code (+) = bld.uom_code AND addr.address_id = bld.address_id AND terr.territory_code = addr.country AND flv.lookup_code = bld.location_type_lookup_code AND flv.lookup_type = 'PN_LOCATION_TYPE' AND plp1.location_park_id (+) = prop.location_park_id AND plp1.language (+) = USERENV('LANG') AND plp2.location_park_id (+) = plp1.parent_location_park_id AND plp2.language (+) = USERENV('LANG') AND bld.property_id = prop.property_id (+) AND loot.lookup_code (+) = bld.lease_or_owned AND loot.lookup_type(+) = 'PN_LEASED_OR_OWNED' AND ocst.lookup_code(+) = NVL(bld.occupancy_status_code,'Y') AND ocst.lookup_type(+) = 'PN_OCCUPANCY_STATUS_CODE' AND disp.lookup_code(+) = bld.disposition_code AND disp.lookup_type(+) = 'PN_DISPOSITION_CODE' AND acct.lookup_code(+) = bld.acc_treatment_code AND acct.lookup_type(+) = 'PN_ACC_TREATMENT_CODE' UNION ALL SELECT flr.rowid row_id, flr.org_id org_id, flr.location_id location_id, flr.location_code location_code, flr.location_alias location_alias, flr.floor location_name, prop.property_id property_id, prop.property_name property_name, bld.location_id building_id, bld.building building, bld.location_code building_location_code, flr.location_id floor_id, flr.floor floor, flr.location_code floor_location_code, TO_NUMBER(NULL) office_id, NULL office, NULL office_location_code, NULL office_common_area_flag, flr.last_update_date last_update_date, flr.last_updated_by last_updated_by, flr.creation_date creation_date, flr.created_by created_by, flr.last_update_login last_update_login, flr.location_park_id location_park_id, flr.location_type_lookup_code location_type_lookup_code, bld.lease_or_owned lease_or_owned, loot.meaning lease_or_owned_tenure, flr.max_capacity max_capacity, flr.optimum_capacity optimum_capacity, flr.rentable_area rentable_area, flr.usable_area usable_area, TO_NUMBER(NULL) building_max_capacity, TO_NUMBER(NULL) building_optimum_capacity, TO_NUMBER(NULL) building_rentable_area, TO_NUMBER(NULL) building_usable_area, flr.max_capacity floor_max_capacity, flr.optimum_capacity floor_optimum_capacity, flr.rentable_area floor_rentable_area, flr.usable_area floor_usable_area, flr.uom_code uom_code, flr.status status, flr.attribute_category attribute_category, flr.attribute1 attribute1, flr.attribute2 attribute2, flr.attribute3 attribute3, flr.attribute4 attribute4, flr.attribute5 attribute5, flr.attribute6 attribute6, flr.attribute7 attribute7, flr.attribute8 attribute8, flr.attribute9 attribute9, flr.attribute10 attribute10, flr.attribute11 attribute11, flr.attribute12 attribute12, flr.attribute13 attribute13, flr.attribute14 attribute14, flr.attribute15 attribute15, uom.unit_of_measure unit_of_measure, bld.address_id address_id, addr.address_line1 address_line1, addr.address_line2 address_line2, addr.address_line3 address_line3, addr.address_line4 address_line4, addr.county county, addr.city city, addr.state state, addr.province province, addr.zip_code zip_code, addr.country country, terr.address_style address_style, addr.territory_id territory_id, addr.addr_attribute_category addr_attribute_category, addr.addr_attribute1 addr_attribute1, addr.addr_attribute2 addr_attribute2, addr.addr_attribute3 addr_attribute3, addr.addr_attribute4 addr_attribute4, addr.addr_attribute5 addr_attribute5, addr.addr_attribute6 addr_attribute6, addr.addr_attribute7 addr_attribute7, addr.addr_attribute8 addr_attribute8, addr.addr_attribute9 addr_attribute9, addr.addr_attribute10 addr_attribute10, addr.addr_attribute11 addr_attribute11, addr.addr_attribute12 addr_attribute12, addr.addr_attribute13 addr_attribute13, addr.addr_attribute14 addr_attribute14, addr.addr_attribute15 addr_attribute15, terr.territory_short_name territory_short_name, pnp_util_func.get_concatenated_address(addr.address_style, addr.address_line1, addr.address_line2, addr.address_line3, addr.address_line4, addr.city, addr.county, addr.state, addr.province, addr.zip_code, terr.territory_short_name ) concatenated_address, flv.meaning location_type, DECODE(plp1.location_park_type, 'OFFPRK', plp1.location_park_id, NULL) office_park_id, DECODE(plp1.location_park_type, 'OFFPRK', plp1.name, NULL) office_park_name, DECODE(plp1.location_park_type, 'REGION', plp1.location_park_id, plp2.location_park_id) region_id, DECODE(plp1.location_park_type, 'REGION', plp1.name, plp2.name) region_name, flr.active_start_date active_start_date, TO_DATE(DECODE(TO_CHAR(flr.active_end_date,'MM/DD/YYYY'),'12/31/4712', NULL,TO_CHAR(flr.active_end_date,'MM/DD/YYYY')),'MM/DD/YYYY') active_end_date, NVL(flr.occupancy_status_code,'Y') occupancy_status_code, ocst.meaning occupancy_status, NVL(flr.assignable_emp,'Y') assignable_emp, NVL(flr.assignable_cc,'Y') assignable_cc, NVL(flr.assignable_cust,'Y') assignable_cust, flr.disposition_code, LTRIM(RTRIM(disp.meaning)) disposition, flr.acc_treatment_code, LTRIM(RTRIM(acct.meaning)) acc_treatment FROM mtl_units_of_measure uom, pn_addresses_all addr, fnd_territories_vl terr, pn_location_parks plp1, pn_location_parks plp2, pn_properties_all prop, fnd_lookups flv, fnd_lookups loot, fnd_lookups ocst, fnd_lookups disp, fnd_lookups acct, pn_locations_all bld, pn_locations flr WHERE flr.location_type_lookup_code IN ('FLOOR' ,'PARCEL') AND flv.lookup_code = flr.location_type_lookup_code AND flv.lookup_type = 'PN_LOCATION_TYPE' AND addr.address_id = bld.address_id AND terr.territory_code = addr.country AND uom.uom_code (+) = flr.uom_code AND bld.property_id = prop.property_id (+) AND loot.lookup_code (+) = bld.lease_or_owned AND plp1.location_park_id (+) = prop.location_park_id AND plp1.language (+) = USERENV('LANG') AND plp2.location_park_id (+) = plp1.parent_location_park_id AND plp2.language (+) = USERENV('LANG') AND bld.location_id = flr.parent_location_id AND ((flr.active_start_date BETWEEN bld.active_start_date AND bld.active_end_date) OR (flr.active_end_date BETWEEN bld.active_start_date AND bld.active_end_date)) AND loot.lookup_type(+) = 'PN_LEASED_OR_OWNED' AND ocst.lookup_code(+) = NVL(flr.occupancy_status_code, 'Y') AND ocst.lookup_type(+) = 'PN_OCCUPANCY_STATUS_CODE' AND disp.lookup_code(+) = flr.disposition_code AND disp.lookup_type(+) = 'PN_DISPOSITION_CODE' AND acct.lookup_code(+) = flr.acc_treatment_code AND acct.lookup_type(+) = 'PN_ACC_TREATMENT_CODE' UNION ALL SELECT off.rowid row_id, off.org_id org_id, off.location_id location_id, off.location_code location_code, off.location_alias location_alias, off.office location_name, prop.property_id property_id, prop.property_name property_name, bld.location_id building_id, bld.building building, bld.location_code building_location_code, flr.location_id floor_id, flr.floor floor, flr.location_code floor_location_code, off.location_id office_id, off.office office, off.location_code office_location_code, off.common_area_flag office_common_area_flag, off.last_update_date last_update_date, off.last_updated_by last_updated_by, off.creation_date creation_date, off.created_by created_by, off.last_update_login last_update_login, off.location_park_id location_park_id, off.location_type_lookup_code location_type_lookup_code, bld.lease_or_owned lease_or_owned, loot.meaning lease_or_owned_tenure, off.max_capacity max_capacity, off.optimum_capacity optimum_capacity, off.rentable_area rentable_area, off.usable_area usable_area, TO_NUMBER(NULL) building_max_capacity, TO_NUMBER(NULL) building_optimum_capacity, TO_NUMBER(NULL) building_rentable_area, TO_NUMBER(NULL) building_usable_area, TO_NUMBER(NULL) floor_max_capacity, TO_NUMBER(NULL) floor_optimum_capacity, TO_NUMBER(NULL) floor_rentable_area, TO_NUMBER(NULL) floor_usable_area, off.uom_code uom_code, off.status status, off.attribute_category attribute_category, off.attribute1 attribute1, off.attribute2 attribute2, off.attribute3 attribute3, off.attribute4 attribute4, off.attribute5 attribute5, off.attribute6 attribute6, off.attribute7 attribute7, off.attribute8 attribute8, off.attribute9 attribute9, off.attribute10 attribute10, off.attribute11 attribute11, off.attribute12 attribute12, off.attribute13 attribute13, off.attribute14 attribute14, off.attribute15 attribute15, uom.unit_of_measure unit_of_measure, bld.address_id address_id, addr.address_line1 address_line1, addr.address_line2 address_line2, addr.address_line3 address_line3, addr.address_line4 address_line4, addr.county county, addr.city city, addr.state state, addr.province province, addr.zip_code zip_code, addr.country country, terr.address_style address_style, addr.territory_id territory_id, addr.addr_attribute_category addr_attribute_category, addr.addr_attribute1 addr_attribute1, addr.addr_attribute2 addr_attribute2, addr.addr_attribute3 addr_attribute3, addr.addr_attribute4 addr_attribute4, addr.addr_attribute5 addr_attribute5, addr.addr_attribute6 addr_attribute6, addr.addr_attribute7 addr_attribute7, addr.addr_attribute8 addr_attribute8, addr.addr_attribute9 addr_attribute9, addr.addr_attribute10 addr_attribute10, addr.addr_attribute11 addr_attribute11, addr.addr_attribute12 addr_attribute12, addr.addr_attribute13 addr_attribute13, addr.addr_attribute14 addr_attribute14, addr.addr_attribute15 addr_attribute15, terr.territory_short_name territory_short_name, pnp_util_func.get_concatenated_address(addr.address_style, addr.address_line1, addr.address_line2, addr.address_line3, addr.address_line4, addr.city, addr.county, addr.state, addr.province, addr.zip_code, terr.territory_short_name ) concatenated_address, flv.meaning location_type, DECODE(plp1.location_park_type, 'OFFPRK', plp1.location_park_id, NULL) office_park_id, DECODE(plp1.location_park_type, 'OFFPRK', plp1.name, NULL) office_park_name, DECODE(plp1.location_park_type, 'REGION', plp1.location_park_id, plp2.location_park_id) region_id, DECODE(plp1.location_park_type, 'REGION', plp1.name, plp2.name) region_name, off.active_start_date active_start_date, TO_DATE(DECODE(TO_CHAR(off.active_end_date,'MM/DD/YYYY'),'12/31/4712', NULL,TO_CHAR(off.active_end_date,'MM/DD/YYYY')),'MM/DD/YYYY') active_end_date, NVL(off.occupancy_status_code,'Y') occupancy_status_code, ocst.meaning occupancy_status, NVL(off.assignable_emp,'Y') assignable_emp, NVL(off.assignable_cc,'Y') assignable_cc, NVL(off.assignable_cust,'Y') assignable_cust, off.disposition_code, LTRIM(RTRIM(disp.meaning)) disposition, off.acc_treatment_code, LTRIM(RTRIM(acct.meaning)) acc_treatment FROM mtl_units_of_measure uom, pn_addresses_all addr, fnd_territories_vl terr, pn_location_parks plp1, pn_location_parks plp2, pn_properties_all prop, fnd_lookups flv, fnd_lookups loot, fnd_lookups ocst, fnd_lookups disp, fnd_lookups acct, pn_locations_all bld, pn_locations_all flr, pn_locations off WHERE off.location_type_lookup_code IN ('OFFICE' ,'SECTION') AND flv.lookup_code = off.location_type_lookup_code AND flv.lookup_type = 'PN_LOCATION_TYPE' AND addr.address_id = bld.address_id AND terr.territory_code = addr.country AND uom.uom_code (+) = off.uom_code AND bld.property_id = prop.property_id (+) AND loot.lookup_code (+) = bld.lease_or_owned AND plp1.location_park_id (+) = prop.location_park_id AND plp1.language (+) = USERENV('LANG') AND plp2.location_park_id (+) = plp1.parent_location_park_id AND plp2.language (+) = USERENV('LANG') AND flr.location_id = off.parent_location_id AND bld.location_id = flr.parent_location_id AND ((off.active_start_date BETWEEN flr.active_start_date AND flr.active_end_date) OR (off.active_end_date BETWEEN flr.active_start_date AND flr.active_end_date)) AND loot.lookup_type(+) = 'PN_LEASED_OR_OWNED' AND ocst.lookup_code(+) = NVL(off.occupancy_status_code,'Y') AND ocst.lookup_type(+) = 'PN_OCCUPANCY_STATUS_CODE' AND disp.lookup_code(+) = off.disposition_code AND disp.lookup_type(+) = 'PN_DISPOSITION_CODE' AND acct.lookup_code(+) = off.acc_treatment_code AND acct.lookup_type (+) = 'PN_ACC_TREATMENT_CODE'

View Text - HTML Formatted

SELECT BLD.ROWID ROW_ID
, BLD.ORG_ID ORG_ID
, BLD.LOCATION_ID LOCATION_ID
, BLD.LOCATION_CODE LOCATION_CODE
, BLD.LOCATION_ALIAS LOCATION_ALIAS
, BLD.BUILDING LOCATION_NAME
, PROP.PROPERTY_ID PROPERTY_ID
, PROP.PROPERTY_NAME PROPERTY_NAME
, BLD.LOCATION_ID BUILDING_ID
, BLD.BUILDING BUILDING
, BLD.LOCATION_CODE BUILDING_LOCATION_CODE
, TO_NUMBER(NULL) FLOOR_ID
, NULL FLOOR
, NULL FLOOR_LOCTION_CODE
, TO_NUMBER(NULL) OFFICE_ID
, NULL OFFICE
, NULL OFFICE_LOCTION_CODE
, NULL OFFICE_COMMON_AREA_FLAG
, BLD.LAST_UPDATE_DATE LAST_UPDATE_DATE
, BLD.LAST_UPDATED_BY LAST_UPDATED_BY
, BLD.CREATION_DATE CREATION_DATE
, BLD.CREATED_BY CREATED_BY
, BLD.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, BLD.LOCATION_PARK_ID LOCATION_PARK_ID
, BLD.LOCATION_TYPE_LOOKUP_CODE LOCATION_TYPE_LOOKUP_CODE
, BLD.LEASE_OR_OWNED LEASE_OR_OWNED
, LOOT.MEANING LEASE_OR_OWNED_TENURE
, BLD.MAX_CAPACITY MAX_CAPACITY
, BLD.OPTIMUM_CAPACITY OPTIMUM_CAPACITY
, BLD.RENTABLE_AREA RENTABLE_AREA
, BLD.USABLE_AREA USABLE_AREA
, BLD.MAX_CAPACITY BUILDING_MAX_CAPACITY
, BLD.OPTIMUM_CAPACITY BUILDING_OPTIMUM_CAPACITY
, BLD.RENTABLE_AREA BUILDING_RENTABLE_AREA
, BLD.USABLE_AREA BUILDING_USABLE_AREA
, TO_NUMBER(NULL) FLOOR_MAX_CAPACITY
, TO_NUMBER(NULL) FLOOR_OPTIMUM_CAPACITY
, TO_NUMBER(NULL) FLOOR_RENTABLE_AREA
, TO_NUMBER(NULL) FLOOR_USABLE_AREA
, BLD.UOM_CODE UOM_CODE
, BLD.STATUS STATUS
, BLD.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, BLD.ATTRIBUTE1 ATTRIBUTE1
, BLD.ATTRIBUTE2 ATTRIBUTE2
, BLD.ATTRIBUTE3 ATTRIBUTE3
, BLD.ATTRIBUTE4 ATTRIBUTE4
, BLD.ATTRIBUTE5 ATTRIBUTE5
, BLD.ATTRIBUTE6 ATTRIBUTE6
, BLD.ATTRIBUTE7 ATTRIBUTE7
, BLD.ATTRIBUTE8 ATTRIBUTE8
, BLD.ATTRIBUTE9 ATTRIBUTE9
, BLD.ATTRIBUTE10 ATTRIBUTE10
, BLD.ATTRIBUTE11 ATTRIBUTE11
, BLD.ATTRIBUTE12 ATTRIBUTE12
, BLD.ATTRIBUTE13 ATTRIBUTE13
, BLD.ATTRIBUTE14 ATTRIBUTE14
, BLD.ATTRIBUTE15 ATTRIBUTE15
, UOM.UNIT_OF_MEASURE UNIT_OF_MEASURE
, BLD.ADDRESS_ID ADDRESS_ID
, ADDR.ADDRESS_LINE1 ADDRESS_LINE1
, ADDR.ADDRESS_LINE2 ADDRESS_LINE2
, ADDR.ADDRESS_LINE3 ADDRESS_LINE3
, ADDR.ADDRESS_LINE4 ADDRESS_LINE4
, ADDR.COUNTY COUNTY
, ADDR.CITY CITY
, ADDR.STATE STATE
, ADDR.PROVINCE PROVINCE
, ADDR.ZIP_CODE ZIP_CODE
, ADDR.COUNTRY COUNTRY
, TERR.ADDRESS_STYLE ADDRESS_STYLE
, ADDR.TERRITORY_ID TERRITORY_ID
, ADDR.ADDR_ATTRIBUTE_CATEGORY ADDR_ATTRIBUTE_CATEGORY
, ADDR.ADDR_ATTRIBUTE1 ADDR_ATTRIBUTE1
, ADDR.ADDR_ATTRIBUTE2 ADDR_ATTRIBUTE2
, ADDR.ADDR_ATTRIBUTE3 ADDR_ATTRIBUTE3
, ADDR.ADDR_ATTRIBUTE4 ADDR_ATTRIBUTE4
, ADDR.ADDR_ATTRIBUTE5 ADDR_ATTRIBUTE5
, ADDR.ADDR_ATTRIBUTE6 ADDR_ATTRIBUTE6
, ADDR.ADDR_ATTRIBUTE7 ADDR_ATTRIBUTE7
, ADDR.ADDR_ATTRIBUTE8 ADDR_ATTRIBUTE8
, ADDR.ADDR_ATTRIBUTE9 ADDR_ATTRIBUTE9
, ADDR.ADDR_ATTRIBUTE10 ADDR_ATTRIBUTE10
, ADDR.ADDR_ATTRIBUTE11 ADDR_ATTRIBUTE11
, ADDR.ADDR_ATTRIBUTE12 ADDR_ATTRIBUTE12
, ADDR.ADDR_ATTRIBUTE13 ADDR_ATTRIBUTE13
, ADDR.ADDR_ATTRIBUTE14 ADDR_ATTRIBUTE14
, ADDR.ADDR_ATTRIBUTE15 ADDR_ATTRIBUTE15
, TERR.TERRITORY_SHORT_NAME TERRITORY_SHORT_NAME
, PNP_UTIL_FUNC.GET_CONCATENATED_ADDRESS(ADDR.ADDRESS_STYLE
, ADDR.ADDRESS_LINE1
, ADDR.ADDRESS_LINE2
, ADDR.ADDRESS_LINE3
, ADDR.ADDRESS_LINE4
, ADDR.CITY
, ADDR.COUNTY
, ADDR.STATE
, ADDR.PROVINCE
, ADDR.ZIP_CODE
, TERR.TERRITORY_SHORT_NAME ) CONCATENATED_ADDRESS
, FLV.MEANING LOCATION_TYPE
, DECODE(PLP1.LOCATION_PARK_TYPE
, 'OFFPRK'
, PLP1.LOCATION_PARK_ID
, NULL) OFFICE_PARK_ID
, DECODE(PLP1.LOCATION_PARK_TYPE
, 'OFFPRK'
, PLP1.NAME
, NULL) OFFICE_PARK_NAME
, DECODE(PLP1.LOCATION_PARK_TYPE
, 'REGION'
, PLP1.LOCATION_PARK_ID
, PLP2.LOCATION_PARK_ID) REGION_ID
, DECODE(PLP1.LOCATION_PARK_TYPE
, 'REGION'
, PLP1.NAME
, PLP2.NAME) REGION_NAME
, BLD.ACTIVE_START_DATE ACTIVE_START_DATE
, TO_DATE(DECODE(TO_CHAR(BLD.ACTIVE_END_DATE
, 'MM/DD/YYYY')
, '12/31/4712'
, NULL
, TO_CHAR(BLD.ACTIVE_END_DATE
, 'MM/DD/YYYY'))
, 'MM/DD/YYYY') ACTIVE_END_DATE
, NVL(BLD.OCCUPANCY_STATUS_CODE
, 'Y') OCCUPANCY_STATUS_CODE
, OCST.MEANING OCCUPANCY_STATUS
, NVL(BLD.ASSIGNABLE_EMP
, 'Y') ASSIGNABLE_EMP
, NVL(BLD.ASSIGNABLE_CC
, 'Y') ASSIGNABLE_CC
, NVL(BLD.ASSIGNABLE_CUST
, 'Y') ASSIGNABLE_CUST
, BLD.DISPOSITION_CODE
, LTRIM(RTRIM(DISP.MEANING)) DISPOSITION
, BLD.ACC_TREATMENT_CODE
, LTRIM(RTRIM(ACCT.MEANING)) ACC_TREATMENT
FROM MTL_UNITS_OF_MEASURE UOM
, PN_ADDRESSES_ALL ADDR
, FND_TERRITORIES_VL TERR
, PN_LOCATION_PARKS PLP1
, PN_LOCATION_PARKS PLP2
, PN_PROPERTIES_ALL PROP
, FND_LOOKUPS FLV
, FND_LOOKUPS LOOT
, FND_LOOKUPS OCST
, FND_LOOKUPS DISP
, FND_LOOKUPS ACCT
, PN_LOCATIONS BLD
WHERE BLD.LOCATION_TYPE_LOOKUP_CODE IN ('BUILDING'
, 'LAND')
AND UOM.UOM_CODE (+) = BLD.UOM_CODE
AND ADDR.ADDRESS_ID = BLD.ADDRESS_ID
AND TERR.TERRITORY_CODE = ADDR.COUNTRY
AND FLV.LOOKUP_CODE = BLD.LOCATION_TYPE_LOOKUP_CODE
AND FLV.LOOKUP_TYPE = 'PN_LOCATION_TYPE'
AND PLP1.LOCATION_PARK_ID (+) = PROP.LOCATION_PARK_ID
AND PLP1.LANGUAGE (+) = USERENV('LANG')
AND PLP2.LOCATION_PARK_ID (+) = PLP1.PARENT_LOCATION_PARK_ID
AND PLP2.LANGUAGE (+) = USERENV('LANG')
AND BLD.PROPERTY_ID = PROP.PROPERTY_ID (+)
AND LOOT.LOOKUP_CODE (+) = BLD.LEASE_OR_OWNED
AND LOOT.LOOKUP_TYPE(+) = 'PN_LEASED_OR_OWNED'
AND OCST.LOOKUP_CODE(+) = NVL(BLD.OCCUPANCY_STATUS_CODE
, 'Y')
AND OCST.LOOKUP_TYPE(+) = 'PN_OCCUPANCY_STATUS_CODE'
AND DISP.LOOKUP_CODE(+) = BLD.DISPOSITION_CODE
AND DISP.LOOKUP_TYPE(+) = 'PN_DISPOSITION_CODE'
AND ACCT.LOOKUP_CODE(+) = BLD.ACC_TREATMENT_CODE
AND ACCT.LOOKUP_TYPE(+) = 'PN_ACC_TREATMENT_CODE' UNION ALL SELECT FLR.ROWID ROW_ID
, FLR.ORG_ID ORG_ID
, FLR.LOCATION_ID LOCATION_ID
, FLR.LOCATION_CODE LOCATION_CODE
, FLR.LOCATION_ALIAS LOCATION_ALIAS
, FLR.FLOOR LOCATION_NAME
, PROP.PROPERTY_ID PROPERTY_ID
, PROP.PROPERTY_NAME PROPERTY_NAME
, BLD.LOCATION_ID BUILDING_ID
, BLD.BUILDING BUILDING
, BLD.LOCATION_CODE BUILDING_LOCATION_CODE
, FLR.LOCATION_ID FLOOR_ID
, FLR.FLOOR FLOOR
, FLR.LOCATION_CODE FLOOR_LOCATION_CODE
, TO_NUMBER(NULL) OFFICE_ID
, NULL OFFICE
, NULL OFFICE_LOCATION_CODE
, NULL OFFICE_COMMON_AREA_FLAG
, FLR.LAST_UPDATE_DATE LAST_UPDATE_DATE
, FLR.LAST_UPDATED_BY LAST_UPDATED_BY
, FLR.CREATION_DATE CREATION_DATE
, FLR.CREATED_BY CREATED_BY
, FLR.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, FLR.LOCATION_PARK_ID LOCATION_PARK_ID
, FLR.LOCATION_TYPE_LOOKUP_CODE LOCATION_TYPE_LOOKUP_CODE
, BLD.LEASE_OR_OWNED LEASE_OR_OWNED
, LOOT.MEANING LEASE_OR_OWNED_TENURE
, FLR.MAX_CAPACITY MAX_CAPACITY
, FLR.OPTIMUM_CAPACITY OPTIMUM_CAPACITY
, FLR.RENTABLE_AREA RENTABLE_AREA
, FLR.USABLE_AREA USABLE_AREA
, TO_NUMBER(NULL) BUILDING_MAX_CAPACITY
, TO_NUMBER(NULL) BUILDING_OPTIMUM_CAPACITY
, TO_NUMBER(NULL) BUILDING_RENTABLE_AREA
, TO_NUMBER(NULL) BUILDING_USABLE_AREA
, FLR.MAX_CAPACITY FLOOR_MAX_CAPACITY
, FLR.OPTIMUM_CAPACITY FLOOR_OPTIMUM_CAPACITY
, FLR.RENTABLE_AREA FLOOR_RENTABLE_AREA
, FLR.USABLE_AREA FLOOR_USABLE_AREA
, FLR.UOM_CODE UOM_CODE
, FLR.STATUS STATUS
, FLR.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, FLR.ATTRIBUTE1 ATTRIBUTE1
, FLR.ATTRIBUTE2 ATTRIBUTE2
, FLR.ATTRIBUTE3 ATTRIBUTE3
, FLR.ATTRIBUTE4 ATTRIBUTE4
, FLR.ATTRIBUTE5 ATTRIBUTE5
, FLR.ATTRIBUTE6 ATTRIBUTE6
, FLR.ATTRIBUTE7 ATTRIBUTE7
, FLR.ATTRIBUTE8 ATTRIBUTE8
, FLR.ATTRIBUTE9 ATTRIBUTE9
, FLR.ATTRIBUTE10 ATTRIBUTE10
, FLR.ATTRIBUTE11 ATTRIBUTE11
, FLR.ATTRIBUTE12 ATTRIBUTE12
, FLR.ATTRIBUTE13 ATTRIBUTE13
, FLR.ATTRIBUTE14 ATTRIBUTE14
, FLR.ATTRIBUTE15 ATTRIBUTE15
, UOM.UNIT_OF_MEASURE UNIT_OF_MEASURE
, BLD.ADDRESS_ID ADDRESS_ID
, ADDR.ADDRESS_LINE1 ADDRESS_LINE1
, ADDR.ADDRESS_LINE2 ADDRESS_LINE2
, ADDR.ADDRESS_LINE3 ADDRESS_LINE3
, ADDR.ADDRESS_LINE4 ADDRESS_LINE4
, ADDR.COUNTY COUNTY
, ADDR.CITY CITY
, ADDR.STATE STATE
, ADDR.PROVINCE PROVINCE
, ADDR.ZIP_CODE ZIP_CODE
, ADDR.COUNTRY COUNTRY
, TERR.ADDRESS_STYLE ADDRESS_STYLE
, ADDR.TERRITORY_ID TERRITORY_ID
, ADDR.ADDR_ATTRIBUTE_CATEGORY ADDR_ATTRIBUTE_CATEGORY
, ADDR.ADDR_ATTRIBUTE1 ADDR_ATTRIBUTE1
, ADDR.ADDR_ATTRIBUTE2 ADDR_ATTRIBUTE2
, ADDR.ADDR_ATTRIBUTE3 ADDR_ATTRIBUTE3
, ADDR.ADDR_ATTRIBUTE4 ADDR_ATTRIBUTE4
, ADDR.ADDR_ATTRIBUTE5 ADDR_ATTRIBUTE5
, ADDR.ADDR_ATTRIBUTE6 ADDR_ATTRIBUTE6
, ADDR.ADDR_ATTRIBUTE7 ADDR_ATTRIBUTE7
, ADDR.ADDR_ATTRIBUTE8 ADDR_ATTRIBUTE8
, ADDR.ADDR_ATTRIBUTE9 ADDR_ATTRIBUTE9
, ADDR.ADDR_ATTRIBUTE10 ADDR_ATTRIBUTE10
, ADDR.ADDR_ATTRIBUTE11 ADDR_ATTRIBUTE11
, ADDR.ADDR_ATTRIBUTE12 ADDR_ATTRIBUTE12
, ADDR.ADDR_ATTRIBUTE13 ADDR_ATTRIBUTE13
, ADDR.ADDR_ATTRIBUTE14 ADDR_ATTRIBUTE14
, ADDR.ADDR_ATTRIBUTE15 ADDR_ATTRIBUTE15
, TERR.TERRITORY_SHORT_NAME TERRITORY_SHORT_NAME
, PNP_UTIL_FUNC.GET_CONCATENATED_ADDRESS(ADDR.ADDRESS_STYLE
, ADDR.ADDRESS_LINE1
, ADDR.ADDRESS_LINE2
, ADDR.ADDRESS_LINE3
, ADDR.ADDRESS_LINE4
, ADDR.CITY
, ADDR.COUNTY
, ADDR.STATE
, ADDR.PROVINCE
, ADDR.ZIP_CODE
, TERR.TERRITORY_SHORT_NAME ) CONCATENATED_ADDRESS
, FLV.MEANING LOCATION_TYPE
, DECODE(PLP1.LOCATION_PARK_TYPE
, 'OFFPRK'
, PLP1.LOCATION_PARK_ID
, NULL) OFFICE_PARK_ID
, DECODE(PLP1.LOCATION_PARK_TYPE
, 'OFFPRK'
, PLP1.NAME
, NULL) OFFICE_PARK_NAME
, DECODE(PLP1.LOCATION_PARK_TYPE
, 'REGION'
, PLP1.LOCATION_PARK_ID
, PLP2.LOCATION_PARK_ID) REGION_ID
, DECODE(PLP1.LOCATION_PARK_TYPE
, 'REGION'
, PLP1.NAME
, PLP2.NAME) REGION_NAME
, FLR.ACTIVE_START_DATE ACTIVE_START_DATE
, TO_DATE(DECODE(TO_CHAR(FLR.ACTIVE_END_DATE
, 'MM/DD/YYYY')
, '12/31/4712'
, NULL
, TO_CHAR(FLR.ACTIVE_END_DATE
, 'MM/DD/YYYY'))
, 'MM/DD/YYYY') ACTIVE_END_DATE
, NVL(FLR.OCCUPANCY_STATUS_CODE
, 'Y') OCCUPANCY_STATUS_CODE
, OCST.MEANING OCCUPANCY_STATUS
, NVL(FLR.ASSIGNABLE_EMP
, 'Y') ASSIGNABLE_EMP
, NVL(FLR.ASSIGNABLE_CC
, 'Y') ASSIGNABLE_CC
, NVL(FLR.ASSIGNABLE_CUST
, 'Y') ASSIGNABLE_CUST
, FLR.DISPOSITION_CODE
, LTRIM(RTRIM(DISP.MEANING)) DISPOSITION
, FLR.ACC_TREATMENT_CODE
, LTRIM(RTRIM(ACCT.MEANING)) ACC_TREATMENT
FROM MTL_UNITS_OF_MEASURE UOM
, PN_ADDRESSES_ALL ADDR
, FND_TERRITORIES_VL TERR
, PN_LOCATION_PARKS PLP1
, PN_LOCATION_PARKS PLP2
, PN_PROPERTIES_ALL PROP
, FND_LOOKUPS FLV
, FND_LOOKUPS LOOT
, FND_LOOKUPS OCST
, FND_LOOKUPS DISP
, FND_LOOKUPS ACCT
, PN_LOCATIONS_ALL BLD
, PN_LOCATIONS FLR
WHERE FLR.LOCATION_TYPE_LOOKUP_CODE IN ('FLOOR'
, 'PARCEL')
AND FLV.LOOKUP_CODE = FLR.LOCATION_TYPE_LOOKUP_CODE
AND FLV.LOOKUP_TYPE = 'PN_LOCATION_TYPE'
AND ADDR.ADDRESS_ID = BLD.ADDRESS_ID
AND TERR.TERRITORY_CODE = ADDR.COUNTRY
AND UOM.UOM_CODE (+) = FLR.UOM_CODE
AND BLD.PROPERTY_ID = PROP.PROPERTY_ID (+)
AND LOOT.LOOKUP_CODE (+) = BLD.LEASE_OR_OWNED
AND PLP1.LOCATION_PARK_ID (+) = PROP.LOCATION_PARK_ID
AND PLP1.LANGUAGE (+) = USERENV('LANG')
AND PLP2.LOCATION_PARK_ID (+) = PLP1.PARENT_LOCATION_PARK_ID
AND PLP2.LANGUAGE (+) = USERENV('LANG')
AND BLD.LOCATION_ID = FLR.PARENT_LOCATION_ID
AND ((FLR.ACTIVE_START_DATE BETWEEN BLD.ACTIVE_START_DATE
AND BLD.ACTIVE_END_DATE) OR (FLR.ACTIVE_END_DATE BETWEEN BLD.ACTIVE_START_DATE
AND BLD.ACTIVE_END_DATE))
AND LOOT.LOOKUP_TYPE(+) = 'PN_LEASED_OR_OWNED'
AND OCST.LOOKUP_CODE(+) = NVL(FLR.OCCUPANCY_STATUS_CODE
, 'Y')
AND OCST.LOOKUP_TYPE(+) = 'PN_OCCUPANCY_STATUS_CODE'
AND DISP.LOOKUP_CODE(+) = FLR.DISPOSITION_CODE
AND DISP.LOOKUP_TYPE(+) = 'PN_DISPOSITION_CODE'
AND ACCT.LOOKUP_CODE(+) = FLR.ACC_TREATMENT_CODE
AND ACCT.LOOKUP_TYPE(+) = 'PN_ACC_TREATMENT_CODE' UNION ALL SELECT OFF.ROWID ROW_ID
, OFF.ORG_ID ORG_ID
, OFF.LOCATION_ID LOCATION_ID
, OFF.LOCATION_CODE LOCATION_CODE
, OFF.LOCATION_ALIAS LOCATION_ALIAS
, OFF.OFFICE LOCATION_NAME
, PROP.PROPERTY_ID PROPERTY_ID
, PROP.PROPERTY_NAME PROPERTY_NAME
, BLD.LOCATION_ID BUILDING_ID
, BLD.BUILDING BUILDING
, BLD.LOCATION_CODE BUILDING_LOCATION_CODE
, FLR.LOCATION_ID FLOOR_ID
, FLR.FLOOR FLOOR
, FLR.LOCATION_CODE FLOOR_LOCATION_CODE
, OFF.LOCATION_ID OFFICE_ID
, OFF.OFFICE OFFICE
, OFF.LOCATION_CODE OFFICE_LOCATION_CODE
, OFF.COMMON_AREA_FLAG OFFICE_COMMON_AREA_FLAG
, OFF.LAST_UPDATE_DATE LAST_UPDATE_DATE
, OFF.LAST_UPDATED_BY LAST_UPDATED_BY
, OFF.CREATION_DATE CREATION_DATE
, OFF.CREATED_BY CREATED_BY
, OFF.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, OFF.LOCATION_PARK_ID LOCATION_PARK_ID
, OFF.LOCATION_TYPE_LOOKUP_CODE LOCATION_TYPE_LOOKUP_CODE
, BLD.LEASE_OR_OWNED LEASE_OR_OWNED
, LOOT.MEANING LEASE_OR_OWNED_TENURE
, OFF.MAX_CAPACITY MAX_CAPACITY
, OFF.OPTIMUM_CAPACITY OPTIMUM_CAPACITY
, OFF.RENTABLE_AREA RENTABLE_AREA
, OFF.USABLE_AREA USABLE_AREA
, TO_NUMBER(NULL) BUILDING_MAX_CAPACITY
, TO_NUMBER(NULL) BUILDING_OPTIMUM_CAPACITY
, TO_NUMBER(NULL) BUILDING_RENTABLE_AREA
, TO_NUMBER(NULL) BUILDING_USABLE_AREA
, TO_NUMBER(NULL) FLOOR_MAX_CAPACITY
, TO_NUMBER(NULL) FLOOR_OPTIMUM_CAPACITY
, TO_NUMBER(NULL) FLOOR_RENTABLE_AREA
, TO_NUMBER(NULL) FLOOR_USABLE_AREA
, OFF.UOM_CODE UOM_CODE
, OFF.STATUS STATUS
, OFF.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, OFF.ATTRIBUTE1 ATTRIBUTE1
, OFF.ATTRIBUTE2 ATTRIBUTE2
, OFF.ATTRIBUTE3 ATTRIBUTE3
, OFF.ATTRIBUTE4 ATTRIBUTE4
, OFF.ATTRIBUTE5 ATTRIBUTE5
, OFF.ATTRIBUTE6 ATTRIBUTE6
, OFF.ATTRIBUTE7 ATTRIBUTE7
, OFF.ATTRIBUTE8 ATTRIBUTE8
, OFF.ATTRIBUTE9 ATTRIBUTE9
, OFF.ATTRIBUTE10 ATTRIBUTE10
, OFF.ATTRIBUTE11 ATTRIBUTE11
, OFF.ATTRIBUTE12 ATTRIBUTE12
, OFF.ATTRIBUTE13 ATTRIBUTE13
, OFF.ATTRIBUTE14 ATTRIBUTE14
, OFF.ATTRIBUTE15 ATTRIBUTE15
, UOM.UNIT_OF_MEASURE UNIT_OF_MEASURE
, BLD.ADDRESS_ID ADDRESS_ID
, ADDR.ADDRESS_LINE1 ADDRESS_LINE1
, ADDR.ADDRESS_LINE2 ADDRESS_LINE2
, ADDR.ADDRESS_LINE3 ADDRESS_LINE3
, ADDR.ADDRESS_LINE4 ADDRESS_LINE4
, ADDR.COUNTY COUNTY
, ADDR.CITY CITY
, ADDR.STATE STATE
, ADDR.PROVINCE PROVINCE
, ADDR.ZIP_CODE ZIP_CODE
, ADDR.COUNTRY COUNTRY
, TERR.ADDRESS_STYLE ADDRESS_STYLE
, ADDR.TERRITORY_ID TERRITORY_ID
, ADDR.ADDR_ATTRIBUTE_CATEGORY ADDR_ATTRIBUTE_CATEGORY
, ADDR.ADDR_ATTRIBUTE1 ADDR_ATTRIBUTE1
, ADDR.ADDR_ATTRIBUTE2 ADDR_ATTRIBUTE2
, ADDR.ADDR_ATTRIBUTE3 ADDR_ATTRIBUTE3
, ADDR.ADDR_ATTRIBUTE4 ADDR_ATTRIBUTE4
, ADDR.ADDR_ATTRIBUTE5 ADDR_ATTRIBUTE5
, ADDR.ADDR_ATTRIBUTE6 ADDR_ATTRIBUTE6
, ADDR.ADDR_ATTRIBUTE7 ADDR_ATTRIBUTE7
, ADDR.ADDR_ATTRIBUTE8 ADDR_ATTRIBUTE8
, ADDR.ADDR_ATTRIBUTE9 ADDR_ATTRIBUTE9
, ADDR.ADDR_ATTRIBUTE10 ADDR_ATTRIBUTE10
, ADDR.ADDR_ATTRIBUTE11 ADDR_ATTRIBUTE11
, ADDR.ADDR_ATTRIBUTE12 ADDR_ATTRIBUTE12
, ADDR.ADDR_ATTRIBUTE13 ADDR_ATTRIBUTE13
, ADDR.ADDR_ATTRIBUTE14 ADDR_ATTRIBUTE14
, ADDR.ADDR_ATTRIBUTE15 ADDR_ATTRIBUTE15
, TERR.TERRITORY_SHORT_NAME TERRITORY_SHORT_NAME
, PNP_UTIL_FUNC.GET_CONCATENATED_ADDRESS(ADDR.ADDRESS_STYLE
, ADDR.ADDRESS_LINE1
, ADDR.ADDRESS_LINE2
, ADDR.ADDRESS_LINE3
, ADDR.ADDRESS_LINE4
, ADDR.CITY
, ADDR.COUNTY
, ADDR.STATE
, ADDR.PROVINCE
, ADDR.ZIP_CODE
, TERR.TERRITORY_SHORT_NAME ) CONCATENATED_ADDRESS
, FLV.MEANING LOCATION_TYPE
, DECODE(PLP1.LOCATION_PARK_TYPE
, 'OFFPRK'
, PLP1.LOCATION_PARK_ID
, NULL) OFFICE_PARK_ID
, DECODE(PLP1.LOCATION_PARK_TYPE
, 'OFFPRK'
, PLP1.NAME
, NULL) OFFICE_PARK_NAME
, DECODE(PLP1.LOCATION_PARK_TYPE
, 'REGION'
, PLP1.LOCATION_PARK_ID
, PLP2.LOCATION_PARK_ID) REGION_ID
, DECODE(PLP1.LOCATION_PARK_TYPE
, 'REGION'
, PLP1.NAME
, PLP2.NAME) REGION_NAME
, OFF.ACTIVE_START_DATE ACTIVE_START_DATE
, TO_DATE(DECODE(TO_CHAR(OFF.ACTIVE_END_DATE
, 'MM/DD/YYYY')
, '12/31/4712'
, NULL
, TO_CHAR(OFF.ACTIVE_END_DATE
, 'MM/DD/YYYY'))
, 'MM/DD/YYYY') ACTIVE_END_DATE
, NVL(OFF.OCCUPANCY_STATUS_CODE
, 'Y') OCCUPANCY_STATUS_CODE
, OCST.MEANING OCCUPANCY_STATUS
, NVL(OFF.ASSIGNABLE_EMP
, 'Y') ASSIGNABLE_EMP
, NVL(OFF.ASSIGNABLE_CC
, 'Y') ASSIGNABLE_CC
, NVL(OFF.ASSIGNABLE_CUST
, 'Y') ASSIGNABLE_CUST
, OFF.DISPOSITION_CODE
, LTRIM(RTRIM(DISP.MEANING)) DISPOSITION
, OFF.ACC_TREATMENT_CODE
, LTRIM(RTRIM(ACCT.MEANING)) ACC_TREATMENT
FROM MTL_UNITS_OF_MEASURE UOM
, PN_ADDRESSES_ALL ADDR
, FND_TERRITORIES_VL TERR
, PN_LOCATION_PARKS PLP1
, PN_LOCATION_PARKS PLP2
, PN_PROPERTIES_ALL PROP
, FND_LOOKUPS FLV
, FND_LOOKUPS LOOT
, FND_LOOKUPS OCST
, FND_LOOKUPS DISP
, FND_LOOKUPS ACCT
, PN_LOCATIONS_ALL BLD
, PN_LOCATIONS_ALL FLR
, PN_LOCATIONS OFF
WHERE OFF.LOCATION_TYPE_LOOKUP_CODE IN ('OFFICE'
, 'SECTION')
AND FLV.LOOKUP_CODE = OFF.LOCATION_TYPE_LOOKUP_CODE
AND FLV.LOOKUP_TYPE = 'PN_LOCATION_TYPE'
AND ADDR.ADDRESS_ID = BLD.ADDRESS_ID
AND TERR.TERRITORY_CODE = ADDR.COUNTRY
AND UOM.UOM_CODE (+) = OFF.UOM_CODE
AND BLD.PROPERTY_ID = PROP.PROPERTY_ID (+)
AND LOOT.LOOKUP_CODE (+) = BLD.LEASE_OR_OWNED
AND PLP1.LOCATION_PARK_ID (+) = PROP.LOCATION_PARK_ID
AND PLP1.LANGUAGE (+) = USERENV('LANG')
AND PLP2.LOCATION_PARK_ID (+) = PLP1.PARENT_LOCATION_PARK_ID
AND PLP2.LANGUAGE (+) = USERENV('LANG')
AND FLR.LOCATION_ID = OFF.PARENT_LOCATION_ID
AND BLD.LOCATION_ID = FLR.PARENT_LOCATION_ID
AND ((OFF.ACTIVE_START_DATE BETWEEN FLR.ACTIVE_START_DATE
AND FLR.ACTIVE_END_DATE) OR (OFF.ACTIVE_END_DATE BETWEEN FLR.ACTIVE_START_DATE
AND FLR.ACTIVE_END_DATE))
AND LOOT.LOOKUP_TYPE(+) = 'PN_LEASED_OR_OWNED'
AND OCST.LOOKUP_CODE(+) = NVL(OFF.OCCUPANCY_STATUS_CODE
, 'Y')
AND OCST.LOOKUP_TYPE(+) = 'PN_OCCUPANCY_STATUS_CODE'
AND DISP.LOOKUP_CODE(+) = OFF.DISPOSITION_CODE
AND DISP.LOOKUP_TYPE(+) = 'PN_DISPOSITION_CODE'
AND ACCT.LOOKUP_CODE(+) = OFF.ACC_TREATMENT_CODE
AND ACCT.LOOKUP_TYPE (+) = 'PN_ACC_TREATMENT_CODE'