update WAREHOUSE set UNIT_PRICE = (select fixed_unit_price from SALE_TRAN_VIEW where
SALE_TRAN_VIEW.TRAN_ID=WAREHOUSE.TRAN_ID and SALE_TRAN_VIEW.PR_KEY = WAREHOUSE.PR_KEY_DETAIL and 
SALE_TRAN_VIEW.PR_KEY_CTU = WAREHOUSE.pr_key AND SALE_TRAN_VIEW.ORGANIZATION_ID=WAREHOUSE.ORGANIZATION_ID AND 
SALE_TRAN_VIEW.ORGANIZATION_ID LIKE '1%')
where WAREHOUSE.ISSUE_RECEIVE='X' AND WAREHOUSE.ORGANIZATION_ID LIKE '1%'
AND EXISTS(select fixed_unit_price from SALE_TRAN_VIEW where
SALE_TRAN_VIEW.TRAN_ID=WAREHOUSE.TRAN_ID and SALE_TRAN_VIEW.PR_KEY = WAREHOUSE.PR_KEY_DETAIL and 
SALE_TRAN_VIEW.PR_KEY_CTU = WAREHOUSE.pr_key AND SALE_TRAN_VIEW.ORGANIZATION_ID=WAREHOUSE.ORGANIZATION_ID AND 
SALE_TRAN_VIEW.ORGANIZATION_ID LIKE '1%')
GO
update WAREHOUSE set UNIT_PRICE = (select fixed_unit_price from PURCHASE_TRAN_VIEW where
PURCHASE_TRAN_VIEW.TRAN_ID=WAREHOUSE.TRAN_ID and PURCHASE_TRAN_VIEW.PR_KEY = WAREHOUSE.PR_KEY_DETAIL and 
PURCHASE_TRAN_VIEW.PR_KEY_CTU = WAREHOUSE.pr_key AND PURCHASE_TRAN_VIEW.ORGANIZATION_ID=WAREHOUSE.ORGANIZATION_ID AND 
PURCHASE_TRAN_VIEW.ORGANIZATION_ID LIKE '1%')
where WAREHOUSE.ISSUE_RECEIVE='N' AND WAREHOUSE.ORGANIZATION_ID LIKE '1%'
AND EXISTS(select fixed_unit_price from PURCHASE_TRAN_VIEW where
PURCHASE_TRAN_VIEW.TRAN_ID=WAREHOUSE.TRAN_ID and PURCHASE_TRAN_VIEW.PR_KEY = WAREHOUSE.PR_KEY_DETAIL and 
PURCHASE_TRAN_VIEW.PR_KEY_CTU = WAREHOUSE.pr_key AND PURCHASE_TRAN_VIEW.ORGANIZATION_ID=WAREHOUSE.ORGANIZATION_ID AND 
PURCHASE_TRAN_VIEW.ORGANIZATION_ID LIKE '1%')
GO
update WAREHOUSE set AMOUNT = (select FIXED_AMOUNT from SALE_TRAN_VIEW where
SALE_TRAN_VIEW.TRAN_ID=WAREHOUSE.TRAN_ID and SALE_TRAN_VIEW.PR_KEY = WAREHOUSE.PR_KEY_DETAIL and 
SALE_TRAN_VIEW.PR_KEY_CTU = WAREHOUSE.pr_key AND SALE_TRAN_VIEW.ORGANIZATION_ID=WAREHOUSE.ORGANIZATION_ID AND 
SALE_TRAN_VIEW.ORGANIZATION_ID LIKE '1%')
where WAREHOUSE.ISSUE_RECEIVE='X' AND WAREHOUSE.ORGANIZATION_ID LIKE '1%'
AND EXISTS(select FIXED_AMOUNT from SALE_TRAN_VIEW where
SALE_TRAN_VIEW.TRAN_ID=WAREHOUSE.TRAN_ID and SALE_TRAN_VIEW.PR_KEY = WAREHOUSE.PR_KEY_DETAIL and 
SALE_TRAN_VIEW.PR_KEY_CTU = WAREHOUSE.pr_key AND SALE_TRAN_VIEW.ORGANIZATION_ID=WAREHOUSE.ORGANIZATION_ID AND 
SALE_TRAN_VIEW.ORGANIZATION_ID LIKE '1%')
GO
update WAREHOUSE set AMOUNT = (select FIXED_AMOUNT from PURCHASE_TRAN_VIEW where
PURCHASE_TRAN_VIEW.TRAN_ID=WAREHOUSE.TRAN_ID and PURCHASE_TRAN_VIEW.PR_KEY = WAREHOUSE.PR_KEY_DETAIL and 
PURCHASE_TRAN_VIEW.PR_KEY_CTU = WAREHOUSE.pr_key AND PURCHASE_TRAN_VIEW.ORGANIZATION_ID=WAREHOUSE.ORGANIZATION_ID AND 
PURCHASE_TRAN_VIEW.ORGANIZATION_ID LIKE '1%')
where WAREHOUSE.ISSUE_RECEIVE='N' AND WAREHOUSE.ORGANIZATION_ID LIKE '1%'
AND EXISTS(select FIXED_AMOUNT from PURCHASE_TRAN_VIEW where
PURCHASE_TRAN_VIEW.TRAN_ID=WAREHOUSE.TRAN_ID and PURCHASE_TRAN_VIEW.PR_KEY = WAREHOUSE.PR_KEY_DETAIL and 
PURCHASE_TRAN_VIEW.PR_KEY_CTU = WAREHOUSE.pr_key AND PURCHASE_TRAN_VIEW.ORGANIZATION_ID=WAREHOUSE.ORGANIZATION_ID AND 
PURCHASE_TRAN_VIEW.ORGANIZATION_ID LIKE '1%')
GO

update WAREHOUSE set AMOUNT = (select FIXED_AMOUNT from POS_SALE_VIEW where
POS_SALE_VIEW.TRAN_ID=WAREHOUSE.TRAN_ID and POS_SALE_VIEW.PR_KEY = WAREHOUSE.PR_KEY_DETAIL and 
POS_SALE_VIEW.PR_KEY_CTU = WAREHOUSE.pr_key AND POS_SALE_VIEW.ORGANIZATION_ID=WAREHOUSE.ORGANIZATION_ID AND 
POS_SALE_VIEW.ORGANIZATION_ID LIKE '1%')
where WAREHOUSE.ISSUE_RECEIVE='X' AND WAREHOUSE.ORGANIZATION_ID LIKE '1%'
AND EXISTS(select FIXED_AMOUNT from POS_SALE_VIEW where
POS_SALE_VIEW.TRAN_ID=WAREHOUSE.TRAN_ID and POS_SALE_VIEW.PR_KEY = WAREHOUSE.PR_KEY_DETAIL and 
POS_SALE_VIEW.PR_KEY_CTU = WAREHOUSE.pr_key AND POS_SALE_VIEW.ORGANIZATION_ID=WAREHOUSE.ORGANIZATION_ID AND 
POS_SALE_VIEW.ORGANIZATION_ID LIKE '1%')
GO
update WAREHOUSE set AMOUNT = (select FIXED_AMOUNT from POS_PURCHASE_VIEW where
POS_PURCHASE_VIEW.TRAN_ID=WAREHOUSE.TRAN_ID and POS_PURCHASE_VIEW.PR_KEY = WAREHOUSE.PR_KEY_DETAIL and 
POS_PURCHASE_VIEW.PR_KEY_CTU = WAREHOUSE.pr_key AND POS_PURCHASE_VIEW.ORGANIZATION_ID=WAREHOUSE.ORGANIZATION_ID AND 
POS_PURCHASE_VIEW.ORGANIZATION_ID LIKE '1%')
where WAREHOUSE.ISSUE_RECEIVE='N' AND WAREHOUSE.ORGANIZATION_ID LIKE '1%'
AND EXISTS(select FIXED_AMOUNT from POS_PURCHASE_VIEW where
POS_PURCHASE_VIEW.TRAN_ID=WAREHOUSE.TRAN_ID and POS_PURCHASE_VIEW.PR_KEY = WAREHOUSE.PR_KEY_DETAIL and 
POS_PURCHASE_VIEW.PR_KEY_CTU = WAREHOUSE.pr_key AND POS_PURCHASE_VIEW.ORGANIZATION_ID=WAREHOUSE.ORGANIZATION_ID AND 
POS_PURCHASE_VIEW.ORGANIZATION_ID LIKE '1%')
GO
update WAREHOUSE set UNIT_PRICE = (select FIXED_UNIT_PRICE from POS_SALE_VIEW where
POS_SALE_VIEW.TRAN_ID=WAREHOUSE.TRAN_ID and POS_SALE_VIEW.PR_KEY = WAREHOUSE.PR_KEY_DETAIL and 
POS_SALE_VIEW.PR_KEY_CTU = WAREHOUSE.pr_key AND POS_SALE_VIEW.ORGANIZATION_ID=WAREHOUSE.ORGANIZATION_ID AND 
POS_SALE_VIEW.ORGANIZATION_ID LIKE '1%')
where WAREHOUSE.ISSUE_RECEIVE='X' AND WAREHOUSE.ORGANIZATION_ID LIKE '1%'
AND EXISTS(select FIXED_UNIT_PRICE from POS_SALE_VIEW where
POS_SALE_VIEW.TRAN_ID=WAREHOUSE.TRAN_ID and POS_SALE_VIEW.PR_KEY = WAREHOUSE.PR_KEY_DETAIL and 
POS_SALE_VIEW.PR_KEY_CTU = WAREHOUSE.pr_key AND POS_SALE_VIEW.ORGANIZATION_ID=WAREHOUSE.ORGANIZATION_ID AND 
POS_SALE_VIEW.ORGANIZATION_ID LIKE '1%')
GO
update WAREHOUSE set UNIT_PRICE = (select FIXED_UNIT_PRICE from POS_PURCHASE_VIEW where
POS_PURCHASE_VIEW.TRAN_ID=WAREHOUSE.TRAN_ID and POS_PURCHASE_VIEW.PR_KEY = WAREHOUSE.PR_KEY_DETAIL and 
POS_PURCHASE_VIEW.PR_KEY_CTU = WAREHOUSE.pr_key AND POS_PURCHASE_VIEW.ORGANIZATION_ID=WAREHOUSE.ORGANIZATION_ID AND 
POS_PURCHASE_VIEW.ORGANIZATION_ID LIKE '1%')
where WAREHOUSE.ISSUE_RECEIVE='N' AND WAREHOUSE.ORGANIZATION_ID LIKE '1%'
AND EXISTS(select FIXED_UNIT_PRICE from POS_PURCHASE_VIEW where
POS_PURCHASE_VIEW.TRAN_ID=WAREHOUSE.TRAN_ID and POS_PURCHASE_VIEW.PR_KEY = WAREHOUSE.PR_KEY_DETAIL and 
POS_PURCHASE_VIEW.PR_KEY_CTU = WAREHOUSE.pr_key AND POS_PURCHASE_VIEW.ORGANIZATION_ID=WAREHOUSE.ORGANIZATION_ID AND 
POS_PURCHASE_VIEW.ORGANIZATION_ID LIKE '1%')
GO