eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_VENDORMERGE_GRP dependencies on PO_VENDOR_LIST_ENTRIES

Line 208: -- modify PO_VENDOR_LIST_ENTRIES

204: PO_LOG.stmt(d_module, d_progress, 'updated PO_HEADERS_ARCHIVE');
205: END IF;
206:
207:
208: -- modify PO_VENDOR_LIST_ENTRIES
209: -- bug3537645 added vendor_site_id condition
210: UPDATE po_vendor_list_entries pv1
211: SET pv1.vendor_id = p_vendor_id,
212: pv1.vendor_site_id = p_vendor_site_id

Line 210: UPDATE po_vendor_list_entries pv1

206:
207:
208: -- modify PO_VENDOR_LIST_ENTRIES
209: -- bug3537645 added vendor_site_id condition
210: UPDATE po_vendor_list_entries pv1
211: SET pv1.vendor_id = p_vendor_id,
212: pv1.vendor_site_id = p_vendor_site_id
213: WHERE pv1.vendor_id = p_dup_vendor_id
214: AND pv1.vendor_site_id = p_dup_vendor_site_id

Line 217: from po_vendor_list_entries pv2

213: WHERE pv1.vendor_id = p_dup_vendor_id
214: AND pv1.vendor_site_id = p_dup_vendor_site_id
215: AND not exists
216: (select vendor_id
217: from po_vendor_list_entries pv2
218: where pv2.vendor_id = p_vendor_id
219: and pv2.vendor_site_id = p_vendor_site_id
220: and pv2.vendor_list_header_id =
221: pv1.vendor_list_header_id);

Line 227: -- DELETE from po_vendor_list_entries pvl

223: -- delete the vendor_list_entry if the new vendor_id would make the
224: -- record a duplicate ie. if modify_po6 had failed
225: -- Anything not moved to the new vendor would have been a duplicate
226: -- and should be deleted
227: -- DELETE from po_vendor_list_entries pvl
228: -- WHERE vendor_id = p_dup_vendor_id
229: -- AND vendor_site_id = p_vendor_site_id;
230: -- Fix for 2086548 commented the above do_sql and wrote the below one
231: DELETE from po_vendor_list_entries pvl

Line 231: DELETE from po_vendor_list_entries pvl

227: -- DELETE from po_vendor_list_entries pvl
228: -- WHERE vendor_id = p_dup_vendor_id
229: -- AND vendor_site_id = p_vendor_site_id;
230: -- Fix for 2086548 commented the above do_sql and wrote the below one
231: DELETE from po_vendor_list_entries pvl
232: WHERE vendor_id = p_dup_vendor_id
233: AND vendor_site_id = p_dup_vendor_site_id ;
234:
235:

Line 237: PO_LOG.stmt(d_module, d_progress, 'updated PO_VENDOR_LIST_ENTRIES');

233: AND vendor_site_id = p_dup_vendor_site_id ;
234:
235:
236: IF (PO_LOG.d_stmt) THEN
237: PO_LOG.stmt(d_module, d_progress, 'updated PO_VENDOR_LIST_ENTRIES');
238: END IF;
239:
240: -- modify PO_AUTOSOURCE_VENDORS
241: UPDATE po_autosource_vendors pav1