How to calculate the formula for 'From Prorate Date Years' in Asset view financial information form.
Hi Experts,
Can you please guide me to calculate the formula for 'From Prorate Date Years' in asset view financial information form.Below screen shot attached.
I am using the below formula but fails for few assets.
select TO_CHAR ( TRUNC (books.life_in_months / 12)
+ (MOD (books.life_in_months, 12) / 100),
'90D00'
) life_in_months,
CASE
WHEN TRUNC
( ( books.life_in_months
- (TRUNC (MONTHS_BETWEEN (SYSDATE,
books.deprn_start_date
)
)
)
)
/ 12
)
+ ( MOD (( books.life_in_months
- (TRUNC (MONTHS_BETWEEN (SYSDATE,
books.deprn_start_date
)
)
)
),
12
)
/ 100
) < 0
THEN 0
ELSE TRUNC ( ( books.life_in_months
- (TRUNC (MONTHS_BETWEEN (SYSDATE,
books.deprn_start_date