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!

Request to create a query that will show all active accounts that have had zero postings in a year

Discussion in 'Oracle Apps Technical' started by Dan Hebert, Apr 7, 2017.

  1. Dan Hebert

    Dan Hebert Starter

    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    10
    Location:
    Hanover, NH
    Brand new to Oracle EBS and GL and I had a request to create a query that will show all active accounts that have had zero postings in a year. Not quite sure where to begin with this request. What tables should I be looking at or has anyone had a similar request that they could share their SQL.

    Thank you in advance for any and all help.

    Dan Hebert (Daniel.Hebert@Hypertherm.com)
    Sr. Developer
    Global Business Applications
    Hypertherm, Inc.
    P.O. Box 5010
    Hanover, NH 03755-5010