Translate

Tuesday, April 2, 2013

Query to Get Organization Details with Organization Code

Query to Get Organization Details with Organization Code



SELECT a.organization_code ,
  a.organization_name       ,
  y.name                    ,
  y.address_line_1          ,
  y.country                 ,
  y.town_or_city
   FROM org_organization_definitions a,
  HR_ORGANIZATION_UNITS_V y
  WHERE a.disable_date IS NULL
AND a.organization_id    = y.organization_id;

6 comments:

  1. Simple, But Really Good and Very Usefull for the beginers like me .. thank you ..

    ReplyDelete
  2. Those guidelines additionally worked to become a good way to recognize that other people online have the identical fervor like mine to grasp a great deal more around this condition. and I could assume you are an expert on this subject. Same as your blog i found another one Digital Presence.Actually I was looking for the same information on internet for Digital Presence and came across your blog. I am impressed by the information that you have on this blog. Thanks a million and please keep up the gratifying work.

    ReplyDelete
  3. Is Organisation code an internal code or something that is defined by the customer?

    ReplyDelete
  4. I jumped on an opportunity to purchase a rental property over the 4th of weekend. Mr Pedro was quick to respond and since this was my first time getting a loan to buy a rental property , he was able to help me walk through the loan process. It was a great experience working with a good and kind loan lender Mr Pedro. I hope you know very well if you are looking for a loan to purchase a property or funding business purposes then Mr Pedro will be able to help you with such a process here his details WhatsApp+1 863 231 0632 . / pedroloanss@gmail.com !”

    ReplyDelete
  5. Indeed organization code can I help me?

    ReplyDelete