APPS.OE_VALUE_TO_ID dependencies on OE_SHIP_TO_ORGS_V

Line 2106: FROM OE_SHIP_TO_ORGS_V

2102:
2103:
2104: CURSOR c_ship_to_org_id(in_sold_to_org_id number) IS
2105: SELECT ORGANIZATION_ID
2106: FROM OE_SHIP_TO_ORGS_V
2107: WHERE ADDRESS_LINE_1 = p_ship_to_address1
2108: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
2109: nvl( p_ship_to_address2, fnd_api.g_miss_char)
2110: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =

Line 2128: FROM OE_SHIP_TO_ORGS_V

2124: AND CUSTOMER_ID = in_sold_to_org_id;
2125:
2126: CURSOR C1(in_sold_to_org_id number) IS
2127: SELECT /*MOAC_SQL_NO_CHANGE*/ ORGANIZATION_ID
2128: FROM OE_SHIP_TO_ORGS_V
2129: WHERE ADDRESS_LINE_1 = p_ship_to_address1
2130: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
2131: nvl( p_ship_to_address2, fnd_api.g_miss_char)
2132: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =

Line 2156: FROM OE_SHIP_TO_ORGS_V

2152: and ship_to_flag = 'Y' and status='A');
2153:
2154: CURSOR C2 IS
2155: SELECT ORGANIZATION_ID
2156: FROM OE_SHIP_TO_ORGS_V
2157: WHERE ADDRESS_LINE_1 = p_ship_to_address1
2158: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
2159: nvl( p_ship_to_address2, fnd_api.g_miss_char)
2160: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =

Line 2307: FROM OE_SHIP_TO_ORGS_V

2303: ELSE
2304:
2305: SELECT ORGANIZATION_ID
2306: INTO l_id
2307: FROM OE_SHIP_TO_ORGS_V
2308: WHERE ADDRESS_LINE_1 = p_ship_to_address1
2309: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
2310: nvl( p_ship_to_address2, fnd_api.g_miss_char)
2311: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =

Line 2340: FROM OE_SHIP_TO_ORGS_V

2336: ELSE
2337:
2338: SELECT /*MOAC_SQL_NO_CHANGE*/ ORGANIZATION_ID
2339: INTO l_id
2340: FROM OE_SHIP_TO_ORGS_V
2341: WHERE ADDRESS_LINE_1 = p_ship_to_address1
2342: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
2343: nvl( p_ship_to_address2, fnd_api.g_miss_char)
2344: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =

Line 2378: FROM OE_SHIP_TO_ORGS_V

2374: ELSE
2375:
2376: SELECT ORGANIZATION_ID
2377: INTO l_id
2378: FROM OE_SHIP_TO_ORGS_V
2379: WHERE ADDRESS_LINE_1 = p_ship_to_address1
2380: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
2381: nvl( p_ship_to_address2, fnd_api.g_miss_char)
2382: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =