APPS.PO_VENDORMERGE_GRP dependencies on PO_VENDORS

Line 297: from po_vendors pov1

293:
294: -- modify PO_REQUISITION_LINES
295: UPDATE PO_REQUISITION_LINES
296: SET suggested_vendor_name = (select pov1.vendor_name
297: from po_vendors pov1
298: where pov1.vendor_id =
299: p_vendor_id),
300: suggested_vendor_location = (select pvs1.vendor_site_code
301: from po_vendor_sites pvs1

Line 305: from po_vendors pov2

301: from po_vendor_sites pvs1
302: where pvs1.vendor_site_id =
303: p_vendor_site_id)
304: WHERE suggested_vendor_name in (select pov2.vendor_name
305: from po_vendors pov2
306: where pov2.vendor_id =
307: p_dup_vendor_id)
308: AND suggested_vendor_location in (select pvs2.vendor_site_code
309: from po_vendor_sites pvs2

Line 330: from po_vendors

326: WHERE vendor_id = p_dup_vendor_id
327: AND vendor_site_id is null
328: AND exists
329: ( select vendor_id
330: from po_vendors
331: where vendor_id = p_dup_vendor_id
332: and nvl(end_date_active, sysdate+1) <= sysdate);
333:
334: IF (PO_LOG.d_stmt) THEN

Line 364: FROM po_vendors PV

360: WHERE PRL.suggested_vendor_id = p_dup_vendor_id
361: AND PRL.suggested_vendor_site_id IS NULL
362: AND EXISTS (
363: SELECT NULL
364: FROM po_vendors PV
365: WHERE PV.vendor_id = p_dup_vendor_id
366: AND NVL(PV.end_date_active, SYSDATE + 1) <= SYSDATE);
367:
368:

Line 409: from po_vendors

405: WHERE poasl1.vendor_id = p_dup_vendor_id
406: AND poasl1.vendor_site_id is null
407: AND exists
408: ( select vendor_id
409: from po_vendors
410: where vendor_id = p_dup_vendor_id
411: and nvl(end_date_active, sysdate+1) <= sysdate)
412: AND not exists
413: ( select vendor_id

Line 432: from po_vendors

428: WHERE vendor_id = p_dup_vendor_id
429: AND vendor_site_id is null
430: AND exists
431: ( select vendor_id
432: from po_vendors
433: where vendor_id = p_dup_vendor_id
434: and nvl(end_date_active, sysdate+1) <= sysdate);
435:
436: IF (PO_LOG.d_stmt) THEN

Line 476: from po_vendors

472: WHERE poasl1.vendor_id = p_dup_vendor_id
473: AND poasl1.vendor_site_id is null
474: AND exists
475: ( select vendor_id
476: from po_vendors
477: where vendor_id = p_dup_vendor_id
478: and nvl(end_date_active, sysdate+1) <= sysdate)
479: AND not exists
480: (select vendor_id

Line 497: from po_vendors

493: WHERE vendor_id = p_dup_vendor_id
494: AND vendor_site_id is null
495: AND exists
496: ( select vendor_id
497: from po_vendors
498: where vendor_id = p_dup_vendor_id
499: and nvl(end_date_active, sysdate+1) <= sysdate) ;
500:
501: IF (PO_LOG.d_stmt) THEN