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 142: -- modify PO_VENDOR_LIST_ENTRIES

138: PO_LOG.stmt(d_module, d_progress, 'updated PO_HEADERS_ARCHIVE');
139: END IF;
140:
141:
142: -- modify PO_VENDOR_LIST_ENTRIES
143: -- bug3537645 added vendor_site_id condition
144: UPDATE po_vendor_list_entries pv1
145: SET pv1.vendor_id = p_vendor_id,
146: pv1.vendor_site_id = p_vendor_site_id

Line 144: UPDATE po_vendor_list_entries pv1

140:
141:
142: -- modify PO_VENDOR_LIST_ENTRIES
143: -- bug3537645 added vendor_site_id condition
144: UPDATE po_vendor_list_entries pv1
145: SET pv1.vendor_id = p_vendor_id,
146: pv1.vendor_site_id = p_vendor_site_id
147: WHERE pv1.vendor_id = p_dup_vendor_id
148: AND pv1.vendor_site_id = p_dup_vendor_site_id

Line 151: from po_vendor_list_entries pv2

147: WHERE pv1.vendor_id = p_dup_vendor_id
148: AND pv1.vendor_site_id = p_dup_vendor_site_id
149: AND not exists
150: (select vendor_id
151: from po_vendor_list_entries pv2
152: where pv2.vendor_id = p_vendor_id
153: and pv2.vendor_site_id = p_vendor_site_id
154: and pv2.vendor_list_header_id =
155: pv1.vendor_list_header_id);

Line 161: -- DELETE from po_vendor_list_entries pvl

157: -- delete the vendor_list_entry if the new vendor_id would make the
158: -- record a duplicate ie. if modify_po6 had failed
159: -- Anything not moved to the new vendor would have been a duplicate
160: -- and should be deleted
161: -- DELETE from po_vendor_list_entries pvl
162: -- WHERE vendor_id = p_dup_vendor_id
163: -- AND vendor_site_id = p_vendor_site_id;
164: -- Fix for 2086548 commented the above do_sql and wrote the below one
165: DELETE from po_vendor_list_entries pvl

Line 165: DELETE from po_vendor_list_entries pvl

161: -- DELETE from po_vendor_list_entries pvl
162: -- WHERE vendor_id = p_dup_vendor_id
163: -- AND vendor_site_id = p_vendor_site_id;
164: -- Fix for 2086548 commented the above do_sql and wrote the below one
165: DELETE from po_vendor_list_entries pvl
166: WHERE vendor_id = p_dup_vendor_id
167: AND vendor_site_id = p_dup_vendor_site_id ;
168:
169:

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

167: AND vendor_site_id = p_dup_vendor_site_id ;
168:
169:
170: IF (PO_LOG.d_stmt) THEN
171: PO_LOG.stmt(d_module, d_progress, 'updated PO_VENDOR_LIST_ENTRIES');
172: END IF;
173:
174: -- modify PO_AUTOSOURCE_VENDORS
175: UPDATE po_autosource_vendors pav1