Wednesday, 12 April 2017

Important tables in oracle property manager

For property details
select * from pn_properties_All

For companies details
SELECT * FROM PN_COMPANIES_ALL

For building details
select * from pn_buildings_v

For the detail of floors in a building
select * from pn_floors_v

For the detail of offices in a single floor
select * from pn_offices_v


For Lease details
SELECT * FROM PN_LEASES_ALL

For payment details
select * from pn_payment_terms_all

For Tenant details
select * from pn_tenancies_all

For Payment schedules
select * from pn_payment_schedules_all

For location details
select * from pn_locations_All 

5 comments:

Interview Question in Oracle OTBI Report

What is Subject Area In OTBI, a Subject Area is a logical view of business data. Under a Subject Area, we have multiple folders , which are...