Blog / Category
Lease
2 articles in this category
Oracle Application Blog
Leases which are expiring 15,30,60,180 days before respectively
This query fetches those leases which are going to expiry within 15,30,60,90,180 days respectively based on the parameter. SELECT GCC.segment4 SOL_I…
Oracle Application Blog
Lease Expired But Not Terminated
Query to Fetch Leases which are expired but not terminated. SELECT GCC.segment4 SOL_ID ,PLA.lease_id…