Forum Stats

  • 3,839,355 Users
  • 2,262,485 Discussions
  • 7,900,946 Comments

Discussions

Country Address Styles

Jean Christenson
Jean Christenson Member Posts: 1
edited Sep 14, 2020 3:53AM in HCM Cloud Service

I'm looking for a SQL to obtain all of the different address styles that exist in Oracle HCM Cloud

Answers

  • User_N2O89
    User_N2O89 Member Posts: 2 Red Ribbon
    edited Aug 31, 2020 6:15AM

    Have you found the SQL or api to get different address styles?

    I have same question.

  • User_N2O89
    User_N2O89 Member Posts: 2 Red Ribbon
    edited Sep 14, 2020 3:53AM

    SELECT hz_format_pub.format_address(p_location_id       => hl.location_id,

                                        p_style_format_code => hl.address_style,

                                        p_line_break        => ',') format_address,

           hp.party_number,

           hl.*

      FROM hz_party_sites hps,

           hz_parties     hp,

           hz_locations   hl

    WHERE 1 = 1

       AND hps.party_id = hp.party_id

       AND hps.location_id = hl.location_id

       AND hp.party_number = 'C1550'

    This sql is useful for formating address  in oracle cloud.