THIS IS DONE

UPDATE SALE_INVOICE SET IGST_AMOUNT = CGST_AMOUNT *2
WHERE INVOICE_DATE >= TO_DATE('01-10-2019','DD-MM-YYYY') AND (COMPANY='R3')
AND (STATUS='O') AND ( UPPER(INVOICE_TYPE) = 'I5' AND (INVOICE_TYPE LIKE 'I5I' OR INVOICE_TYPE LIKE 'I5%'))
AND ENTRY_NO IN (485,484,483);
UPDATE SALE_INVOICE SET CGST_AMOUNT = 0, SGST_AMOUNT = 0
WHERE INVOICE_DATE >= TO_DATE('01-10-2019','DD-MM-YYYY') AND (COMPANY='R3')
AND (STATUS='O') AND ( UPPER(INVOICE_TYPE) = 'I5' AND (INVOICE_TYPE LIKE 'I5I' OR INVOICE_TYPE LIKE 'I5%'))
AND ENTRY_NO IN (485,484,483) ;

UPDATE GL_POSTING_DETAILS A SET SUB_ACCOUNT_CODE = '0037' , AMOUNT = AMOUNT *2
WHERE ACCOUNT_CODE = '12020'  AND COMPANY = 'R3' AND VOUCHER_TYPE = 'I5'
AND SUB_ACCOUNT_CODE IN ('0038')
AND VOUCHER_DATE >'01/10/2019'
AND VOUCHER_NUMBER IN (485,484,483)  ;
DELETE GL_POSTING_DETAILS A  WHERE ACCOUNT_CODE = '12020' AND SUB_ACCOUNT_CODE IN ('0039')
AND VOUCHER_DATE >'01/10/2019'  AND COMPANY = 'R3'  AND VOUCHER_TYPE = 'I5'
AND VOUCHER_NUMBER IN (485,484,483) ;