You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Identify customer from ar_statement_delivery

Received Response
edited May 10, 2023 7:59AM in Receivables & Collections 1 comment


How to identify the customer from the ar_statement_delivery table

Content (required):

I have written a sql in order to identify the customer_name, account_number, email address and date of statement run for that customer

The query is:

select hp.party_name customer_name,






from hz_parties hp,

    hz_cust_accounts hca,

    hz_cust_acct_sites_all hcasa,  

    ar_statement_delivery asd,  

     (select emailpeo.email_address,


      from HZ_CONTACT_POINTS emailpeo,

          HZ_RELATIONSHIPS RelationshipPEO           

      where RelationshipPEO.SUBJECT_ID     = EmailPEO.OWNER_TABLE_ID(+)

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!