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 

2 comments:

AOL SYLLABUS: PREREQUISITE SQL PL/SQL D2K GENERAL INTRODUCTION KNOW HOW OF ERP Version of Oracle Apps 11i Comparison of 10.7/11...