Siebel Business Process & Functionality (MOSC)

MOSC Banner

Siebel upgrade update Quote Item and Order Item amount columns?

edited Dec 16, 2016 12:12AM in Siebel Business Process & Functionality (MOSC) 1 commentAnswered
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
)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center