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!

Need Link or Join condition.

Discussion in 'Oracle Apps Technical' started by jagadekara, Feb 12, 2014.

  1. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Hi all,

    I am developing a report in AR. In that i am using ar_cash_receipts_all and hz_parties tables. So I need the join condition between those tables.

    could you please help me....
     
  2. sambuduk

    sambuduk Forum Advisor

    Messages:
    242
    Likes Received:
    73
    Trophy Points:
    455
    Location:
    Hyderabad , Telangana
    Hi Brother,

    For What purpose you are using hz_parties???

    If you are using for customer then check the below query.

    Code (SQL):

    SELECT  acr.receipt_number
           , hp.party_name customer_name
    FROM  ar_cash_receipts_all acr
          , hz_cust_accounts hca
          , hz_parties hp
    WHERE  acr.pay_from_customer = hca.cust_account_id
    AND    hca.STATUS = 'A'
    AND    hca.party_id = hp.party_id    
     

    Regards
    Sambasiva Reddy.K
     
    jagadekara likes this.
  3. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Hi Sambu,
    Thanks...

    Yes I am using it for customer.

    what is hca.STATUS = 'A'?
     
  4. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi Jagadekara,

    Either the customer account is Active or Inactive. Status = 'A' refers the sql to pull only Active Customer Accounts.
     
    jagadekara likes this.