Siebel upgrade update Quote Item and Order Item amount columns?
Hi,
We are upgrading from 7.7 to 8.1 and during upgrade below script it getting executed,
update S_QUOTE_ITEM
set NET_PRI = CASE WHEN NET_PRI IS NOT NULL
THEN NET_PRI
ELSE
(
select nvl
(UNIT_PRI
,nvl(ADJ_UNIT_PRI * (100.00 - S_QUOTE_ITEM.DISCNT_PERCENT) * 0.01
,nvl(ADJ_UNIT_PRI - S_QUOTE_ITEM.DISCNT_AMT
,nvl(ADJ_UNIT_PRI * (100.00 - DQ.DISCNT_PERCENT) * 0.01
,nvl(ADJ_UNIT_PRI
, 0
)))))
from S_DOC_QUOTE DQ
where DQ.ROW_ID = S_QUOTE_ITEM.SD_ID
)
END
,QUOTE_ITM_CURCY_CD = (
select DQ.CURCY_CD
from S_DOC_QUOTE DQ
where DQ.ROW_ID = S_QUOTE_ITEM.SD_ID
)
0