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
     
  2. Michael___

    Michael___ Newly Initiated

    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    30
    Location:
    Sol System
    I'm also newish to Oracle

    You'll probably want these two tables:
    select * from AR.AR_PAYMENT_SCHEDULES_ALL PSA inner join ar.HZ_CUST_ACCOUNTS CA on PSA.customer_id = ca.CUST_ACCOUNT_ID

    This will show customers with an invoice at some time.
    Note - I think there might exists customer accounts where no invoice yet exists. (I'm still learning....)