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