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!

Sales Return

Discussion in 'Oracle Apps Technical' started by rogerbnny, Mar 15, 2009.

  1. rogerbnny

    rogerbnny Active Member

    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    75
    hi
    can any body provide me sales return query the scenerio is

    items are sold to customers and invoice is created and later customer has return back some item due to damage we have to reduced item as well amount
    but the parameter should be invoice number
     
  2. Sadik

    Sadik Community Moderator Forum Guru

    Messages:
    1,906
    Likes Received:
    252
    Trophy Points:
    1,455
    hi roger

    Could you please explain your scenario a little more, what data are you looking for in your query, i mean which columns?
     
  3. rogerbnny

    rogerbnny Active Member

    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    75
    tables that is have used is
    ra_customers for customer name,number
    ra_customer_trx_all trx_id,trx_number,trx_date
    from ra_customer -->hz_cust_acct for account number
    hz_cust_acct_sites,
    hz_cust_act_sites_usage for ship_to location(for location where the items have been shiipped)
     
  4. rogerbnny

    rogerbnny Active Member

    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    75
    the columns are
    invoice number,sales order number,location,customer name,customer number,credit memo number,itemcode,product,pack,unit
    tables that iam using
    ra_customers,(customer_name,customer_number,customer_type)
    ra_customers_trx_all,(customer_trx_type_id,trx_number(invoicenumber)trx_date

    ra_custtomer_trx_lines_all(qty_ordered,qty_credited,qty_invoiced
    mtl_system_item_b (itemcode,product,unitprice)
    hz_cust_acct_sites_all for location
    but i need to join these tables to get location
    ra_customers,hz_cust_acct,hz_acct_sites,hz_cust_acct_site_usage

    kindly reply