Update f_intry_bal_dly_trf SQL script

Requirement: Update the logic in attached SQL file only for the columns mentioned below. The logic is mentioned in attached Excel.

 

1. prod_plant_lot_location_key
2. qty_available
3. qty_mrp_nettable

 

 

 

Acceptance Criteria:

 

1. Primary Keys to handle the duplicates are prod_plant_lot_location_key and capture_dt_yyyymmdd