how get query manage locations
Can someone help me with the query to obtain the information shown in the "manage locations" option?
Basic details
name
status
code
Main address
Main address usage type
I need this information to run it in OTBI
I've been reviewing the hz_locations table, but it doesn't give me all the information I need.
thanks in advance
Tagged:
0