Lease

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_ID       ,gl_flexfields_pkg.get_description_SQL(GCC.chart_of_accounts_id ,4,GCC.segment4) BRANCH_NAME      …

Read More

Lease Expired But Not Terminated

Query to Fetch Leases which are expired but not terminated.  SELECT        GCC.segment4  SOL_ID       ,PLA.lease_id Lease_number       ,PLDA.attribute7 Agreement_no       ,PAA.address_line1||’,’||PAA.address_line2||’,’||PAA.address_line3||’,’||PAA.address_line4||’,’||PAA.city||’,’||PAA.state…

Read More