Advertisement
Guest User

Untitled

a guest
Feb 19th, 2017
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.97 KB | None | 0 0
  1. update HIS_IP_InvoiceLine set AD_CLIENT_ID = 1000001, AD_ORG_ID = 0 where (AD_CLIENT_ID <> 1000001
  2. OR AD_ORG_ID <> 0 OR CREATEDBY = 0) and HIS_PatientHistory_ID in (2174805);
  3. update HIS_SERVICE_MEDICINE set AD_CLIENT_ID = 1000001, AD_ORG_ID = 0 where (AD_CLIENT_ID <> 1000001
  4. OR AD_ORG_ID <> 0 OR CREATEDBY = 0) and HIS_PatientHistory_ID in (2174805);
  5. update HIS_STORAGE_DOCUMENT set AD_CLIENT_ID = 1000001, AD_ORG_ID = 0 where (AD_CLIENT_ID <> 1000001
  6. OR AD_ORG_ID <> 0 OR CREATEDBY = 0) and HIS_PatientHistory_ID in (2174805);
  7. update HIS_CONSUMPTIONGROUP set AD_CLIENT_ID = 1000001, AD_ORG_ID = 0 where (AD_CLIENT_ID <> 1000001
  8. OR AD_ORG_ID <> 0 OR CREATEDBY = 0) and HIS_PatientHistory_ID in (2174805);
  9.  
  10. update HIS_STORAGE_DOCUMENTLINE set AD_CLIENT_ID = 1000001, AD_ORG_ID = 0 where (AD_CLIENT_ID <> 1000001
  11. OR AD_ORG_ID <> 0 OR CREATEDBY = 0)
  12. and HIS_STORAGE_DOCUMENT_ID in (select HIS_STORAGE_DOCUMENT_ID from HIS_STORAGE_DOCUMENT where HIS_PatientHistory_ID in (2174805));
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement