APPS.OE_VALUE_TO_ID dependencies on OE_DELIVER_TO_ORGS_V

Line 519: FROM OE_DELIVER_TO_ORGS_V

515: lcustomer_relations varchar2(1);
516:
517: CURSOR c_deliver_to_org_id(in_sold_to_org_id number) IS
518: SELECT ORGANIZATION_ID
519: FROM OE_DELIVER_TO_ORGS_V
520: WHERE ADDRESS_LINE_1 = p_deliver_to_address1
521: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
522: nvl( p_deliver_to_address2, fnd_api.g_miss_char)
523: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =

Line 541: FROM OE_DELIVER_TO_ORGS_V

537: AND CUSTOMER_ID = in_sold_to_org_id;
538:
539: CURSOR C1(in_sold_to_org_id number) IS
540: SELECT /*MOAC_SQL_NO_CHANGE*/ ORGANIZATION_ID
541: FROM OE_DELIVER_TO_ORGS_V
542: WHERE ADDRESS_LINE_1 = p_deliver_to_address1
543: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
544: nvl( p_deliver_to_address2, fnd_api.g_miss_char)
545: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =

Line 569: FROM OE_DELIVER_TO_ORGS_V

565: RELATED_CUST_ACCOUNT_ID = in_sold_to_org_id
566: and ship_to_flag = 'Y' and status='A');
567: CURSOR C2 IS
568: SELECT ORGANIZATION_ID
569: FROM OE_DELIVER_TO_ORGS_V
570: WHERE ADDRESS_LINE_1 = p_deliver_to_address1
571: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
572: nvl( p_deliver_to_address2, fnd_api.g_miss_char)
573: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =

Line 717: FROM OE_DELIVER_TO_ORGS_V

713: return l_id;
714: ELSE
715: SELECT ORGANIZATION_ID
716: INTO l_id
717: FROM OE_DELIVER_TO_ORGS_V
718: WHERE ADDRESS_LINE_1 = p_deliver_to_address1
719: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
720: nvl( p_deliver_to_address2, fnd_api.g_miss_char)
721: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =

Line 760: FROM OE_DELIVER_TO_ORGS_V

756: END IF;
757:
758: SELECT /*MOAC_SQL_NO_CHANGE*/ ORGANIZATION_ID
759: INTO l_id
760: FROM OE_DELIVER_TO_ORGS_V
761: WHERE ADDRESS_LINE_1 = p_deliver_to_address1
762: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
763: nvl( p_deliver_to_address2, fnd_api.g_miss_char)
764: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =

Line 804: FROM OE_DELIVER_TO_ORGS_V

800: return l_id;
801: ELSE
802: SELECT ORGANIZATION_ID
803: INTO l_id
804: FROM OE_DELIVER_TO_ORGS_V
805: WHERE ADDRESS_LINE_1 = p_deliver_to_address1
806: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
807: nvl( p_deliver_to_address2, fnd_api.g_miss_char)
808: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =