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 

3 comments:

GL Code combination query in oracle fusion

 select  gcc.Code_Combination_id Account_Code_Combination_Id, CONCATENATED_SEGMENTS Account_Code_Combination,  segment1, segment2, segment3,...