APPS.PO_VENDORMERGE_GRP dependencies on PO_HEADERS

Line 109: UPDATE po_headers_draft_all pohd

105: --
106: --Since in CLM we have Multi-Mod for Supplier Change, Supplier Merge is not required.
107: --therefore ignore CLM documents
108: --update Commercial Modifications
109: UPDATE po_headers_draft_all pohd
110: SET pohd.vendor_id = p_vendor_id,
111: pohd.vendor_site_id = p_vendor_site_id,
112: pohd.vendor_contact_id = (SELECT vendor_contact_id
113: FROM ap_supplier_contacts

Line 143: po_headers ph

139: PGOA.last_update_login = FND_GLOBAL.login_id
140: WHERE PGOA.vendor_site_id = p_dup_vendor_site_id
141: AND NOT EXISTS (SELECT 'Exclude CLM Document'
142: FROM po_doc_style_headers pods,
143: po_headers ph
144: WHERE pods.style_id = ph.style_id
145: AND ph.PO_HEADER_ID= pgoa.PO_HEADER_ID
146: AND NVL(pods.CLM_FLAG,'N') = 'Y')
147: AND EXISTS ( SELECT 'Exclude draft_type is not equal to MOD'

Line 156: UPDATE po_headers ph

152: --
153:
154: --Bug 5435716 START
155: --Bug 12728157
156: UPDATE po_headers ph
157: SET ph.vendor_id = p_vendor_id,
158: ph.vendor_site_id = p_vendor_site_id,
159: ph.vendor_contact_id = (SELECT vendor_contact_id
160: FROM ap_supplier_contacts

Line 192: -- modify PO_HEADERS_ARCHIVE

188:
189:
190: --Bug 5435716 END
191:
192: -- modify PO_HEADERS_ARCHIVE
193: UPDATE po_headers_archive pha
194: SET pha.vendor_id = p_vendor_id,
195: pha.vendor_site_id = p_vendor_site_id
196: WHERE pha.vendor_id = p_dup_vendor_id

Line 193: UPDATE po_headers_archive pha

189:
190: --Bug 5435716 END
191:
192: -- modify PO_HEADERS_ARCHIVE
193: UPDATE po_headers_archive pha
194: SET pha.vendor_id = p_vendor_id,
195: pha.vendor_site_id = p_vendor_site_id
196: WHERE pha.vendor_id = p_dup_vendor_id
197: AND pha.vendor_site_id = p_dup_vendor_site_id

Line 204: PO_LOG.stmt(d_module, d_progress, 'updated PO_HEADERS_ARCHIVE');

200: WHERE pods.style_id = pha.style_id
201: AND NVL(pods.CLM_FLAG,'N') = 'Y');
202:
203: IF (PO_LOG.d_stmt) THEN
204: PO_LOG.stmt(d_module, d_progress, 'updated PO_HEADERS_ARCHIVE');
205: END IF;
206:
207:
208: -- modify PO_VENDOR_LIST_ENTRIES

Line 350: po_headers ph

346: PGOA.last_update_login = FND_GLOBAL.login_id
347: WHERE PGOA.vendor_site_id = p_dup_vendor_site_id
348: AND NOT EXISTS (SELECT 'CLM Document' --
349: FROM po_doc_style_headers pods,
350: po_headers ph
351: WHERE pods.style_id = ph.style_id
352: AND ph.PO_HEADER_ID= pgoa.PO_HEADER_ID
353: AND NVL(pods.CLM_FLAG,'N') = 'Y');
354:

Line 363: po_headers ph

359: PGOA.last_update_login = FND_GLOBAL.login_id
360: WHERE PGOA.vendor_site_id = p_dup_vendor_site_id
361: AND NOT EXISTS (SELECT 'CLM Document' --
362: FROM po_doc_style_headers pods,
363: po_headers ph
364: WHERE pods.style_id = ph.style_id
365: AND ph.PO_HEADER_ID= pgoa.PO_HEADER_ID
366: AND NVL(pods.CLM_FLAG,'N') = 'Y');
367: IF (PO_LOG.d_stmt) THEN