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!

GL Balances - SQL Query Help

Discussion in 'Oracle Apps Technical' started by murliram, Aug 20, 2013.

  1. murliram

    murliram Active Member

    Messages:
    48
    Likes Received:
    0
    Trophy Points:
    100
    Hello All,

    I am trying to build a query which will give a monthly bucket for GL Balance which are due.I have built the below query which has the basic information but i am trying to rollup GL Periods which i am not able to find any link also. Could any one please help me in deriving the monthly bucket using GL Periods or is there any other way for this.

    My output should look like this

    Department Account Type Concatinated Segment Closing Bal JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC

    Please help me on this ....Need to get this done ASAP.
     

    Attached Files: