Is there a Oracle DB package / function to retrieve a country code from a given location_id?
Summary:
Hello,
I'm looking for a Package / function which I can use in a BIP datamodel to retrieve a country code for a given location id.
Some of the seeded datamodel within BIP in Oracle fusion use builtin functions for retrieving certain data or to format data, e.g.
AR_BPA_UTILS_PKG
HZ_FORMAT_PUB
examples are:
fnd_currency.get_format_mask(invoice_currency_code, 40 )
AR_BPA_UTILS_PKG.fn_get_contact_name(bill_to_contact_id)
AR_BPA_UTILS_PKG.fn_get_phone(bill_to_contact_id)
or formatting functions like
HZ_FORMAT_PUB.format_address(location_id)
Tagged:
1