1) Status Wise row Update & Delete off Step:1 ===== Create Region--> Intarective Grid SQL Query: select ANIMAL_ID, SUPPLIER_ID, ANIMAL_TYPE, STATUS, CASE WHEN STATUS ='S' THEN 'X' ELSE '…
Note: ------ 0 to 0 up = All without 0 = Pending ==================================== Where ( case when :P22011_TYPE=' ALL ' then 'TRUE' when :P22011_TYPE=' PENDING ' then …