DBA Data[Home] [Help]

APPS.PO_VENDORMERGE_GRP dependencies on PO_VENDORS

Line 374: from po_vendors pov1

370:
371: -- modify PO_REQUISITION_LINES
372: UPDATE PO_REQUISITION_LINES prl
373: SET prl.suggested_vendor_name = (select pov1.vendor_name
374: from po_vendors pov1
375: where pov1.vendor_id =
376: p_vendor_id),
377: prl.suggested_vendor_location = (select pvs1.vendor_site_code
378: from po_vendor_sites pvs1

Line 382: from po_vendors pov2

378: from po_vendor_sites pvs1
379: where pvs1.vendor_site_id =
380: p_vendor_site_id)
381: WHERE prl.suggested_vendor_name in (select pov2.vendor_name
382: from po_vendors pov2
383: where pov2.vendor_id =
384: p_dup_vendor_id)
385: AND prl.suggested_vendor_location in (select pvs2.vendor_site_code
386: from po_vendor_sites pvs2

Line 416: from po_vendors

412: WHERE prl.vendor_id = p_dup_vendor_id
413: AND prl.vendor_site_id is null
414: AND exists
415: ( select vendor_id
416: from po_vendors
417: where vendor_id = p_dup_vendor_id
418: and nvl(end_date_active, sysdate+1) <= sysdate)
419: AND NOT EXISTS (SELECT 'Exclude CLM Document'
420: FROM Po_Requisition_Headers_All prha

Line 454: FROM po_vendors PV

450: WHERE PRL.suggested_vendor_id = p_dup_vendor_id
451: AND PRL.suggested_vendor_site_id IS NULL
452: AND EXISTS (
453: SELECT NULL
454: FROM po_vendors PV
455: WHERE PV.vendor_id = p_dup_vendor_id
456: AND NVL(PV.end_date_active, SYSDATE + 1) <= SYSDATE);
457:
458:

Line 499: from po_vendors

495: WHERE poasl1.vendor_id = p_dup_vendor_id
496: AND poasl1.vendor_site_id is null
497: AND exists
498: ( select vendor_id
499: from po_vendors
500: where vendor_id = p_dup_vendor_id
501: and nvl(end_date_active, sysdate+1) <= sysdate)
502: AND not exists
503: ( select vendor_id

Line 522: from po_vendors

518: WHERE vendor_id = p_dup_vendor_id
519: AND vendor_site_id is null
520: AND exists
521: ( select vendor_id
522: from po_vendors
523: where vendor_id = p_dup_vendor_id
524: and nvl(end_date_active, sysdate+1) <= sysdate);
525:
526: IF (PO_LOG.d_stmt) THEN

Line 566: from po_vendors

562: WHERE poasl1.vendor_id = p_dup_vendor_id
563: AND poasl1.vendor_site_id is null
564: AND exists
565: ( select vendor_id
566: from po_vendors
567: where vendor_id = p_dup_vendor_id
568: and nvl(end_date_active, sysdate+1) <= sysdate)
569: AND not exists
570: (select vendor_id

Line 587: from po_vendors

583: WHERE vendor_id = p_dup_vendor_id
584: AND vendor_site_id is null
585: AND exists
586: ( select vendor_id
587: from po_vendors
588: where vendor_id = p_dup_vendor_id
589: and nvl(end_date_active, sysdate+1) <= sysdate) ;
590:
591: IF (PO_LOG.d_stmt) THEN