EBS Customizations (MOSC)

MOSC Banner

Customers created for Internal Sales order in Requisiton form

edited Dec 17, 2009 12:04AM in EBS Customizations (MOSC) 2 commentsAnswered
HI,

  This issue is with related to Internal requisition.

  How can we  map destination organisation and location and the associated customer / customers.

1)I created a query which shows all the inv org

   select organization_name, organization_id, organization_code   from org_organization_definitions   where     nvl(disable_date, trunc(sysdate + 1)) > trunc(sysdate) 2)I  then wrote a query to find the location attached to the organization using Select location_code,location_id,description from (  select lot.location_code location_code,        loc.location_id location_id,         lot.description description   from hr_locations_all loc,       hr_locations_all_tl lot   where nvl (loc.business_group_id, nvl(hr_general.get_business_group_id, -99) ) = nvl (hr_general.get_business_group_id, -99)

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