Snowflake - Calculating days from multiple tables based on specific condition

Can anyone help in snowflake query to get the correct result. I am working on snowflake and have 3 tables as ZBK, ZLF and ZT05

TAG(int) is the day of the month. It is only to compare with day(inv_dt) It can be 00
MONA(int) is the No. of Months i.e. 01 means 1 Month...
FAEL is the day of the month i.e 20 means 20th day of the month.

TAG1 is the column which has additional days which needs to be added in the final sum calculation without any condition.

If the inv_dt is less then TAG then the no. of days calculation should consider specific Term for a vendor and apply the rule of calculation as per that specific tag row.

example - for 1st row, Tag is 16 and day(inv_dt) is 7 which is less then Tag then while calculating no. of days it should take value of Fael i.e. 20 and mona as 00 and count no. of days from 7th Feb to 20th Feb which is 13.

For 2nd row, Tag is 25 and day(inv_dt) is 17 which is less then 25 but greater then 16 of the same vendor and term group. then calculation should be Fael i.e. 20 and mona as 01 and count no. of days from 17th March to 20th April which is 34 (14 day of March + 20 Days of April)

Table ZBK              Table ZLF        ZT05
Inv_Dt    Vendor  |  Vendor   Term |  TAG  FAEL MONA Term  TAG1
7/02/23   100428  |  100428   AA5  |  16   20    00   AA5   00
17/3/23   100428  |  100429   CA2  |  25   20    01   AA5   07
26/3/23   100428  |                |  31   10    02   AA5   15
22/4/23   100429  |                |  00   07    02   CA2   5

Desired Output (sum_days column) - List column just for reference.
inv_dt	   term	 tag tag1	fael  mona	sum_days  list
2023-02-07	AA5	 16	  00     20	   00	  13	  13
2023-03-17	AA5	 25	  07     20	   01	  41	  14+20   + 07(tag1)
2023-03-26	AA5	 31	  15     10	   02	  60	  5+30+10 + 15(tag1) 
2023-04-22	CA2	 00	  05      7	   02	  51	  8+31+7  + 05(tag1)

I have a sample query on SQL as below

with joined as(
select ZBK.Inv_Dt, ZLF.TERM 
  from ZBK
    join ZLF on ZBK.Vendor = ZLF.Vendor)
select Inv_Dt, TERM, TAG, FAEL, MONA, sum(FAEL) sum_days,
       string_agg(FAEL, '+') within group (order by n) list
from(
  select Inv_Dt, a.TERM, TAG, FAEL, MONA,n, 
       case 
       when MONA = 0 and FAEL > day(Inv_Dt) then FAEL - day(Inv_Dt)
       when n = 0 then datediff(day, Inv_Dt, last_day(Inv_Dt)) 
       when n = MONA then FAEL 
       else day(last_day(dateadd(month, n, Inv_Dt)))
       end days
  from joined a
  cross apply(select top 1 * from ZT05 b
                    where b.TERM = a.TERM and day(Inv_Dt) < TAG order by TAG) b,
  cross apply(select n from (values (0),(1),(2),(3),(4),(5)) v(n) where n <= MONA) v) t
group by Inv_Dt, TERM, TAG, FAEL, MONA

I am looking for a query on snowflake.
When I am running this query after modification of string_agg to listagg() and cross apply to lateral in snowflake. I am getting error of SQL compilation error: Unsupported subquery type cannot be evaluated
Thank you

This should give you what you want:

SELECT ZBK.INV_DT
,ZLF.TERM
,T1.TAG, T1.FAEL, T1.MONA
,DATEDIFF('DAYS',ZBK.INV_DT, 
    ADD_MONTHS(
                DATE_FROM_PARTS(YEAR(ZBK.INV_DT), MONTH(ZBK.INV_DT), T1.FAEL)
                ,T1.MONA
              )
         ) "SUM_DAYS"
FROM ZBK
INNER JOIN ZLF ON ZBK.VENDOR = ZLF.VENDOR
INNER JOIN ZT05 T1 ON ZLF.TERM = T1.TERM AND T1.TAG = 
    (SELECT MIN(T2.TAG) FROM ZT05 T2 WHERE ZLF.TERM = T2.TERM AND T2.TAG > DAY(ZBK.INV_DT) )
ORDER BY ZBK.INV_DT
;

I've assumed that the tag value has to be greater than the invoice day but if the rule is <= then you'll need to adjust the "T2.TAG > DAY(ZBK.INV_DT)"