Blog / Category
Property Management
4 articles in this category
Oracle Application Blog
Script to get Normalized Exp Amount from Property Manager
CREATE OR REPLACE FUNCTION APPS.PN_NORM_EXP(p_payment_item_id number, p_ccid number) RETURN NUMBER IS l_accrued_amount number; l_cash_amount …
Oracle Application Blog
Script to get Cash from Property Manager
CREATE OR REPLACE FUNCTION APPS.PN_CASH(p_payment_item_id number, p_ccid number) RETURN NUMBER IS l_cash_amount number; l_max_item_id&…
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…