[Home] [Help]
APPS.PNRX_LEASE_OPTIONS dependencies on PN_ADDRESSES_ALL
Line 494: pn_addresses_all pa,
490: usable_area) USABLE_AREA,
491: loc.gross_area GROSS_AREA,
492: fnd.meaning TENURE
493: FROM pn_locations_all loc,
494: pn_addresses_all pa,
495: fnd_lookups fnd,
496: fnd_lookups fl1
497: WHERE pa.address_id(+) = loc.address_id
498: AND loc.lease_or_owned = fnd.lookup_code(+)