I believe I should be able to help you with the above requirement.
Can you please elaborate little more on the requirement? Are you referring 'Organization' above as the Operating unit?
Please confirm on the questions as well.
Basically if we select Responsibility that starts with HA and HAO ,it need to fetch all organizations associated with the Selected responsibility.
its working fine for HAO resp to fetch data,but at the same time if we select HA resp it also needs to fetch data.
U can find the code that we did.
select org.organization_code,org.name, org.organization_id,
- org.location_code, org.address_line_1, org.address_line_2,
- org.address_line_3, decode(org.town_or_city, null, null,org.town_or_city
|| ', ')
|| decode(org.region_1, null, null, org.region_1 || ', ')
|| decode(org.region_2, null, null, org.region_2 || ', ') ||
decode(org.region_3, null, null, org.region_3 || ', ')
|| decode(org.postal_code, null, null, org.postal_code || ', ')
|| decode(org.country, null, null, org.country)
from oe_ship_from_orgs_v org,apps.org_access oe
where oe.organization_id = org.organization_id
plz reply me as early as possible
This personalization is for warehouse field in purchasing.