delete data from transactions

delete data from transactions

delete from TRANSACTION_DETAILS_P where TR_SEQ_NO in(select TR_SEQ_NO from TRANSACTION_MASTER_P where ard_no='122999')



delete from TRANSACTION_MASTER_P where ard_no='122999'

delete from FAILED_TRANSACTIONS_TRAILER_P where TR_SEQ_NO in(select TR_SEQ_NO from FAILED_TRANSACTIONS_P where SHOP_NO	='122999')

delete from FAILED_TRANSACTIONS_P where SHOP_NO	='122999'

delete from STOCK_TRAILER_P where DN_SEQ_NO in(select DN_SEQ_NO from STOCK_HEADER_P where shop_no='122999')

delete from STOCK_HEADER_P where shop_no='122999'

delete from [dbo].[STOCK_INVENTORY_P] where shop_no='122999'

update  MEMBER_ENTITLEMENT set consumed=0
where SHOP_NO='122999'

delete from  [dbo].[AGG_TRANSACTION] where GEOGRAPHY='Callippus'


delete from [dbo].[AGG_TRANSACTION_DETAILS] where SHOP_NO='122999'

delete from UID_RESPONSE_P where SHOP_NO='122999'