BI Publisher (MOSC)

MOSC Banner

How can I join FLA_PROPERTIES_ALL or any other FLA lease table with HZ_LOCATIONS table?

I am trying to get the address which we can see under the Assets tab for a particular lease I tried joining INTERNAL_LOCATION_ID and EXTERNAL_LOCATION_ID from the FLA_PROPERTIES_ALL with LOCATION_ID of HZ_LOCATIONS table but I was not getting any result in that .

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center