Financial Management - PSFT (MOSC)

MOSC Banner

AR_OVRDUE/FCAMOUNT SQL looks wrong

edited Mar 21, 2014 12:06PM in Financial Management - PSFT (MOSC) 2 commentsAnswered

Hi, all.

Don't know that this SQL is causing us any problems, but it looks wrong compared to similar SQL in other steps in the same App Engine Section.

For FCAMT1 the following SQL is coded:

UPDATE %Table(OC_ITEM1_TAO)

  SET OC_AMT = %RoundCurrency(%SQL(ARFNCHRG$FCAMOUNT), BAL_CURRENCY )

WHERE PROCESS_INSTANCE = %Bind(PROCESS_INSTANCE)

   AND (EXISTS (

SELECT 'X'

  FROM %Table(OC_TBL_TAO)

WHERE INCL_OC_IN_CALC = 'Y'

   AND OC_RATE_TYPE IN ('P','S')

   AND PROCESS_INSTANCE = %Bind(PROCESS_INSTANCE)

   AND OC_PROMPT_SETID = %Table(OC_ITEM1_TAO).OC_PROMPT_SETID

   AND OC_ID = %Table(OC_ITEM1_TAO).OC_ID)

Tagged:

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