1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Exact replacement query in r12

Discussion in 'Oracle Apps Technical' started by suma, Sep 3, 2015.

  1. suma

    suma Active Member

    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    55
    Location:
    Bangalore
    Hi All,


    I need exact replcement query in R12 for below query.It is just view query we are doing upgrde from 11i to R12.


    Thanks in advance.

    Regards
    RS
     
    Last edited: Sep 7, 2015
  2. krasnoslobodtsev_si

    krasnoslobodtsev_si Forum Genius

    Messages:
    626
    Likes Received:
    129
    Trophy Points:
    810
    Location:
    Russian Federation
    Hi.
    Syntax of your query is maintained in oracle 12c
    If it is necessary to rewrite request with use of innovations of oracle 12c (for example WITH_PLSQL, pragam udf for function , order fetch/offset ... and etc...), then it is necessary to provide you the complete information: that you need to improve
     
  3. kiran.marla

    kiran.marla Forum Genius

    Messages:
    403
    Likes Received:
    52
    Trophy Points:
    505
    Location:
    Khammam
    Hi Suma, do you face any issues in executing this query in R12. If yes, where are you facing this issue ??
     
  4. anasazii

    anasazii Starter

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    10
    Location:
    US
    the main thing that changes from 11i to R12 is the po_vendor tables move to the AP schema.

    I don't see that you are qualifying your tables so I don't know that there is even an issue...does the existing query run ok for you in your R12 environment?

    If not the first thing I would do is replace the following..the columns names are still the same.

    po_vendor --> ap_suppliers
    po_vendor_sites_all --> ap_supplier_sites_all