APPS.OE_CNCL_VALUE_TO_ID dependencies on OE_DELIVER_TO_ORGS_V

Line 318: FROM OE_DELIVER_TO_ORGS_V

314: lcustomer_relations varchar2(1);
315:
316: CURSOR c_deliver_to_org_id IS
317: SELECT ORGANIZATION_ID
318: FROM OE_DELIVER_TO_ORGS_V
319: WHERE ADDRESS_LINE_1 = p_deliver_to_address1
320: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
321: nvl( p_deliver_to_address2, fnd_api.g_miss_char)
322: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =

Line 339: FROM OE_DELIVER_TO_ORGS_V

335: AND CUSTOMER_ID = p_sold_to_org_id;
336:
337: CURSOR C1 IS
338: SELECT /*MOAC_SQL_NO_CHANGE*/ ORGANIZATION_ID
339: FROM OE_DELIVER_TO_ORGS_V
340: WHERE ADDRESS_LINE_1 = p_deliver_to_address1
341: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
342: nvl( p_deliver_to_address2, fnd_api.g_miss_char)
343: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =

Line 366: FROM OE_DELIVER_TO_ORGS_V

362: RELATED_CUST_ACCOUNT_ID = p_sold_to_org_id
363: and ship_to_flag = 'Y');
364: CURSOR C2 IS
365: SELECT ORGANIZATION_ID
366: FROM OE_DELIVER_TO_ORGS_V
367: WHERE ADDRESS_LINE_1 = p_deliver_to_address1
368: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
369: nvl( p_deliver_to_address2, fnd_api.g_miss_char)
370: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =

Line 417: FROM OE_DELIVER_TO_ORGS_V

413: return l_id;
414: ELSE
415: SELECT ORGANIZATION_ID
416: INTO l_id
417: FROM OE_DELIVER_TO_ORGS_V
418: WHERE ADDRESS_LINE_1 = p_deliver_to_address1
419: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
420: nvl( p_deliver_to_address2, fnd_api.g_miss_char)
421: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =

Line 460: FROM OE_DELIVER_TO_ORGS_V

456: END IF;
457:
458: SELECT /*MOAC_SQL_NO_CHANGE*/ ORGANIZATION_ID
459: INTO l_id
460: FROM OE_DELIVER_TO_ORGS_V
461: WHERE ADDRESS_LINE_1 = p_deliver_to_address1
462: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
463: nvl( p_deliver_to_address2, fnd_api.g_miss_char)
464: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =

Line 503: FROM OE_DELIVER_TO_ORGS_V

499: return l_id;
500: ELSE
501: SELECT ORGANIZATION_ID
502: INTO l_id
503: FROM OE_DELIVER_TO_ORGS_V
504: WHERE ADDRESS_LINE_1 = p_deliver_to_address1
505: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
506: nvl( p_deliver_to_address2, fnd_api.g_miss_char)
507: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =