Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- remove non-existent object codes
- UPDATE AR_SYS_INFO_T SET refund_fin_obj_cd=3103 WHERE refund_fin_obj_cd=3063;
- UPDATE AR_SYS_INFO_T SET univ_clr_object_cd=3103 WHERE univ_clr_object_cd=3063;
- UPDATE AR_SYS_INFO_T SET pmt_clr_fin_obj_cd=3103 WHERE pmt_clr_fin_obj_cd=3063;
- -- remove non-existent org codes
- UPDATE AR_SYS_INFO_T SET PRCS_ORG_CD='9998' WHERE PRCS_ORG_CD='3310';
- UPDATE AR_SYS_INFO_T SET PRCS_ORG_CD='9983' WHERE PRCS_ORG_CD='8507';
- UPDATE AR_SYS_INFO_T SET PRCS_ORG_CD='9996' WHERE PRCS_ORG_CD='6201';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement