Customers created for Internal Sales order in Requisiton form
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)0