--UPDATE FROM 8.7.4.3 TO 8.7.4.4


DROP TABLE VERSION_8_7_4_3;



/*  VERSION_8_7_4_4  */
CREATE TABLE VERSION_8_7_4_4 (
	 DUMMY	NUMBER	    NULL
)
;

UPDATE YEBS SET YEBS_ORG_SPECIALRATE=YEBS_SPECIALRATE WHERE YEBS_ORG_SPECIALRATE IS NULL;

UPDATE YEBR SET YEBR_ORG_MANUALPRICE=YEBR_MANUALPRICE WHERE YEBR_ORG_MANUALPRICE IS NULL;

UPDATE YMRD SET YMRD_ORG_AMOUNT=YMRD_YFCA_AMOUNT WHERE YMRD_ORG_AMOUNT IS NULL;

UPDATE YEMI SET YEMI_ORG_PRICE=YEMI_PRICE WHERE YEMI_ORG_PRICE IS NULL;

UPDATE YBEF SET YBEF_ORG_REV_AMOUNT=YBEF_REV_AMOUNT WHERE YBEF_ORG_REV_AMOUNT IS NULL;
