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!

SQL Query from the seeded report in Inventory Module-'Transaction historical summary'

Discussion in 'Oracle Apps Technical' started by bk_mathew, Dec 30, 2010.

  1. bk_mathew

    bk_mathew Active Member

    Messages:
    18
    Likes Received:
    0
    Trophy Points:
    80
    Hi Friends,

    Can anybody help me in getting the SQL Query from the seeded report in Inventory Module - 'Transaction historical summary'.

    Thanks & Regards,

    Mathew
     
  2. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Re: SQL Query from the seeded report in Inventory Module-'Transaction historical summ

    Hi,

    Go to system Administrator responsibility and click on concurrent- program- define press f11 and enter Transaction historical summary and press control+ f11 here cpy executable name and to executable window f11 in short name enter executable name and control f11 then you will get rdf name then go to server inv top reports there copy your report INVTRHAN.rdf and open it through report builder. There you will get SQL Query.

    Hope this will help you...