Follow us: Connect on YouTube Connect on YouTube Connect on YouTube

Pages

Wednesday, 11 May 2016

To Get Receivables Bill To Query

select distinct hca.account_number ,
                hcsu.cust_acct_site_id, hcsu.site_use_id,
                hps.party_site_number ,
                hp.party_name , hl1.address1 street1,
                hl1.address2 street2, hl1.address3 street3,
                hl1.address4 street4, hl1.house_number house, hl1.city,
                hl1.postal_code,
                decode (hcp.phone_line_type,
                        'gen', hcp.phone_area_code || hcp.phone_number,
                        null
                       ) phone_number,
                 hl1.country, hl1.state region,
                   decode (hcp.phone_line_type,
                        'fax', hcp.phone_area_code || hcp.phone_number,
                        null
                       ) fax_number,
                hp.email_address
           from hz_parties hp,
                hz_locations hl1,
                hz_cust_site_uses_all hcsu,
                hz_cust_acct_sites_all hcas,
                hz_party_sites hps,
                hz_cust_accounts hca,
                hz_contact_points hcp
          where 1 = 1
            and hcsu.cust_acct_site_id = hcas.cust_acct_site_id
            and hcas.party_site_id = hps.party_site_id
            and hps.location_id = hl1.location_id
            and hp.party_id = hcp.owner_table_id(+)
            and hp.party_id = hps.party_id
            and hca.cust_account_id = hcas.cust_account_id
            and hcsu.site_use_code = 'bill_to'
--            and hp.party_name like 'a%'

       order by hp.party_name;
Share this article :

2 comments:

  1. Hi There,


    In total awe…. So much respect and gratitude to you folks for pulling off such amazing blogs without missing any points on the To Get Receivables Bill To Query. Kudos!


    I would like to load the image from the web browser and save the image on Oracle table!
    I have Oracle XE database on Linux server

    When I run this script, I received an error: Internal Server Error!
    I can not find what's wrong!

    The scrept run o.k. if I use only class!!!
    With enctype="multipart/form-data the error is Internal Server Error!

    Super likes !!! for this amazing post. I thinks everyone should bookmark this.


    Thank you,
    Sunny

    ReplyDelete
  2. Hi There,

    Jeez oh man,while I applaud for your writing , it’s just so damn straight to the point To Get Receivables Bill To Query .

    I need help to identify the amount of time spent on a campaign using logon and logoff times. The issue I have is that I can have several logoff times that have the same logon time. I could use the maximum logoff time by campaign but sometimes the campaign will repeat itself in the day. Example of Data is attached.

    I should end up with 4 records.

    LOGON LOGOFF CAMPAIGN
    02/24/2017 8:05:04 AM 02/24/2017 9:00:41 AM CO
    02/24/2017 9:01:22 AM 02/24/2017 10:22:52 AM PR
    02/24/2017 10:37:46 AM 02/24/2017 12:29:44 PM PR
    02/24/2017 3:29:57 PM 02/24/2017 4:00:36 PM CO

    But nice Article Mate! Great Information! Keep up the good work!

    Shukran,
    Preethi.

    ReplyDelete