Update Logic in f_invntry_bal_dly_hist SQL

Requirement:

 

modify or add the logic in the attached SQL file only for the fields mentioned below, rest remains unchanged in the logic. The logics for the below mentioned columns are in attached excel

 

1. g_qty_financial_nettable
2. g_qty_mrp_nettable
3. g_qty_in_transit
4. currency_key
5. g_lot_nbr