Results 1 to 2 of 2

Thread: Hi

  1. #1
    Join Date
    Aug 2011

    Smile Unanswered: Hi

    Can anyone help me out of this query

    trunc (case when substr(APPS.OE_ORDER_LINES_ALL.ATTRIBUTE2,1,3) = 'APC' then 'APAC'
    when substr(oela.ATTRIBUTE2,1,3) = 'EMA' then 'EMEA'
    when UPPER(substr(oela.ATTRIBUTE2,1,3)) = 'MEM' then 'Americas'
    else 'UNKNOWN' END) DC_GEO

  2. #2
    Join Date
    Mar 2007
    No without knowing, what is this expression supposed to return.

    Why are you using TRUNC function on string values?
    What should be the result of e.g. TRUNC( 'UNKNOWN' ) ?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts