Friday 5 January 2018

Query to Get Organization Location Details

SELECT  ood.organization_code ,
        ood.organization_name,
        hou.name,
        hou.address_line_1,
        hou.country,
        hou.town_or_city
FROM org_organization_definitions ood,
     hr_organization_units_v hou
WHERE ood.disable_date IS NULL
AND ood.organization_id    = hou.organization_id;

Your's
Amar Alam

3 comments:

Anonymous said...

Nice blog..! I really loved reading through this article. Thanks for sharing such an amazing post with us and keep blogging...A well-written article of app Thank You for Sharing with Us pmp training in chennai | pmp training institute in chennai | pmp training centers in chennai| pmp training in velachery | pmp training near me |

Realtime Experts said...

you blog is very useful SAP bods learners.very informative content and detailed topic explanation.one of the recommanded content.we are very glad to leave a comment here.thank you for sharing your knowledge.also visit our blogs
Oracle apps Training in Bangalore

Home Services said...

Perhaps you’re making a common mistake by looking at much more than you need. How to interpret pareto chart when it comes to getting the greatest return on investment (ROI) from data analysis in PPC advertising, you can save a lot of time and money by just focusing on the areas that are really producing results or not.

Post a Comment