APPS.OE_EXTERNAL_CREDIT_PVT dependencies on OE_INVOICE_TO_ORGS_V

Line 310: FROM OE_INVOICE_TO_ORGS_V

306: ) RETURN NUMBER
307: IS
308: CURSOR c_bill_to_site_use_id IS
309: SELECT /* MOAC_SQL_NO_CHANGE */ ORGANIZATION_ID
310: FROM OE_INVOICE_TO_ORGS_V
311: WHERE ADDRESS_LINE_1 = p_bill_to_address1
312: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
313: nvl( p_bill_to_address2, fnd_api.g_miss_char)
314: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =

Line 332: FROM OE_INVOICE_TO_ORGS_V

328: and address_status='A'; --2752321
329:
330: CURSOR C1 IS
331: SELECT /* MOAC_SQL_NO_CHANGE */ ORGANIZATION_ID
332: FROM OE_INVOICE_TO_ORGS_V
333: WHERE ADDRESS_LINE_1 = p_bill_to_address1
334: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
335: nvl( p_bill_to_address2, fnd_api.g_miss_char)
336: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =

Line 362: FROM OE_INVOICE_TO_ORGS_V

358: AND bill_to_flag = 'Y');
359:
360: CURSOR C2 IS
361: SELECT /* MOAC_SQL_NO_CHANGE */ ORGANIZATION_ID
362: FROM OE_INVOICE_TO_ORGS_V
363: WHERE ADDRESS_LINE_1 = p_bill_to_address1
364: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
365: nvl( p_bill_to_address2, fnd_api.g_miss_char)
366: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =

Line 421: FROM OE_INVOICE_TO_ORGS_V

417: RETURN l_bill_to_site_use_id;
418: ELSE
419: SELECT /* MOAC_SQL_NO_CHANGE */ ORGANIZATION_ID
420: INTO l_bill_to_site_use_id
421: FROM OE_INVOICE_TO_ORGS_V
422: WHERE ADDRESS_LINE_1 = p_bill_to_address1
423: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
424: nvl( p_bill_to_address2, fnd_api.g_miss_char)
425: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =

Line 463: FROM OE_INVOICE_TO_ORGS_V

459: -- oe_debug_pub.add('org='||l_org);
460:
461: SELECT /* MOAC_SQL_NO_CHANGE */ ORGANIZATION_ID
462: INTO l_bill_to_site_use_id
463: FROM OE_INVOICE_TO_ORGS_V
464: WHERE ADDRESS_LINE_1 = p_bill_to_address1
465: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
466: nvl( p_bill_to_address2, fnd_api.g_miss_char)
467: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =

Line 507: FROM OE_INVOICE_TO_ORGS_V

503: RETURN l_bill_to_site_use_id;
504: ELSE
505: SELECT ORGANIZATION_ID
506: INTO l_bill_to_site_use_id
507: FROM OE_INVOICE_TO_ORGS_V
508: WHERE ADDRESS_LINE_1 = p_bill_to_address1
509: AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
510: nvl( p_bill_to_address2, fnd_api.g_miss_char)
511: AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =