APPS.OE_VALUE_TO_ID dependencies on OE_INVOICE_TO_ORGS_V

Line 1196: FROM OE_INVOICE_TO_ORGS_V

1192: lcustomer_relations varchar2(1);
1193:
1194: CURSOR c_invoice_to_org_id(in_sold_to_org_id number) IS
1195: SELECT ORGANIZATION_ID
1196: FROM OE_INVOICE_TO_ORGS_V
1197: WHERE ADDRESS_LINE_1 = p_invoice_to_address1
1198: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1199: nvl( p_invoice_to_address2, fnd_api.g_miss_char)
1200: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =

Line 1218: FROM OE_INVOICE_TO_ORGS_V

1214: AND CUSTOMER_ID = in_sold_to_org_id;
1215:
1216: CURSOR C1(in_sold_to_org_id in number) IS
1217: SELECT /*MOAC_SQL_NO_CHANGE*/ ORGANIZATION_ID
1218: FROM OE_INVOICE_TO_ORGS_V
1219: WHERE ADDRESS_LINE_1 = p_invoice_to_address1
1220: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1221: nvl( p_invoice_to_address2, fnd_api.g_miss_char)
1222: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =

Line 1246: FROM OE_INVOICE_TO_ORGS_V

1242: RELATED_CUST_ACCOUNT_ID = in_sold_to_org_id
1243: and bill_to_flag = 'Y' and status='A');
1244: CURSOR C2 IS
1245: SELECT ORGANIZATION_ID
1246: FROM OE_INVOICE_TO_ORGS_V
1247: WHERE ADDRESS_LINE_1 = p_invoice_to_address1
1248: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1249: nvl( p_invoice_to_address2, fnd_api.g_miss_char)
1250: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =

Line 1397: FROM OE_INVOICE_TO_ORGS_V

1393: return l_id;
1394: ELSE
1395: SELECT ORGANIZATION_ID
1396: INTO l_id
1397: FROM OE_INVOICE_TO_ORGS_V
1398: WHERE ADDRESS_LINE_1 = p_invoice_to_address1
1399: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1400: nvl( p_invoice_to_address2, fnd_api.g_miss_char)
1401: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =

Line 1442: FROM OE_INVOICE_TO_ORGS_V

1438: oe_debug_pub.add( 'ORG='||L_ORG ) ;
1439: END IF;
1440: SELECT /*MOAC_SQL_NO_CHANGE*/ ORGANIZATION_ID
1441: INTO l_id
1442: FROM OE_INVOICE_TO_ORGS_V
1443: WHERE ADDRESS_LINE_1 = p_invoice_to_address1
1444: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1445: nvl( p_invoice_to_address2, fnd_api.g_miss_char)
1446: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =

Line 1487: FROM OE_INVOICE_TO_ORGS_V

1483: return l_id;
1484: ELSE
1485: SELECT ORGANIZATION_ID
1486: INTO l_id
1487: FROM OE_INVOICE_TO_ORGS_V
1488: WHERE ADDRESS_LINE_1 = p_invoice_to_address1
1489: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
1490: nvl( p_invoice_to_address2, fnd_api.g_miss_char)
1491: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =