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 :

3 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
  3. Oracle Apps R12 and Oracle Fusion Cloud Self Paced Online Training Videos Published on Udemy with Life Time Access & Live Meeting Support to Clear your Queries. Avail 25% to 80% discount. Please Check https://www.oracleappstechnical.com for Never Before Offers and Discount Coupon Codes.

    ReplyDelete