PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

COMPOSITE QUERY

I am trying to create an expression in a composite query.  The expression will be a new field within the query.

the following CASE statement results in an execution error.

case when #{PRICE_CHANGE.A.CHNG_NBR_VALUE:11} IS NOT NULL then #{PRICE_CHANGE.A_CHNG_NBR_VALUE} * #{ORIG_QTY.A.CHNG_NBR_VALUE:10}

WHEN #{QTY_CHANGE.A.CHNG_NBR_VALUE:12} IS NOT NULL then #{QTY_CHANGE.A.CHNG_NBR_VALUE} *#{ORIG_PRICE.A.CHNG_NBR_VALUE:9} else 0 END

Sample data:

I want to be able to have the new column be:  original qty = 5 X price change = 50.  result:  250

Any assistance is greatly appreciated.

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