1921: -- AND XXXX_val_column = p_ship_from_org
1922:
1923: --bug#4287327
1924: BEGIN
1925: select distinct organization_id INTO l_id from oe_ship_from_orgs_v
1926: where organization_code= p_ship_from_org;
1927: EXCEPTION
1928: WHEN NO_DATA_FOUND THEN
1929: select distinct organization_id INTO l_id from oe_ship_from_orgs_v
1925: select distinct organization_id INTO l_id from oe_ship_from_orgs_v
1926: where organization_code= p_ship_from_org;
1927: EXCEPTION
1928: WHEN NO_DATA_FOUND THEN
1929: select distinct organization_id INTO l_id from oe_ship_from_orgs_v
1930: where name= p_ship_from_org;
1931: WHEN TOO_MANY_ROWS THEN
1932: l_id := fnd_api.g_miss_num;
1933: END;