DBA Data[Home] [Help]

APPS.OE_VALUE_TO_ID dependencies on OE_SHIP_FROM_ORGS_V

Line 1925: select distinct organization_id INTO l_id from oe_ship_from_orgs_v

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

Line 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;