DBA Data[Home] [Help]

APPS.OKL_VENDORMERGE_GRP dependencies on OKL_LEASE_OPPS_ALL_B

Line 266: --Update OKL_LEASE_OPPS_ALL_B for references of Vendor

262: LAST_UPDATE_DATE = l_last_update_date,
263: LAST_UPDATE_LOGIN = l_last_update_login
264: WHERE SUPPLIER_ID = p_dup_vendor_id;
265:
266: --Update OKL_LEASE_OPPS_ALL_B for references of Vendor
267: UPDATE OKL_LEASE_OPPS_ALL_B
268: SET SUPPLIER_ID = p_vendor_id,
269: LAST_UPDATED_BY = l_last_updated_by,
270: LAST_UPDATE_DATE = l_last_update_date,

Line 267: UPDATE OKL_LEASE_OPPS_ALL_B

263: LAST_UPDATE_LOGIN = l_last_update_login
264: WHERE SUPPLIER_ID = p_dup_vendor_id;
265:
266: --Update OKL_LEASE_OPPS_ALL_B for references of Vendor
267: UPDATE OKL_LEASE_OPPS_ALL_B
268: SET SUPPLIER_ID = p_vendor_id,
269: LAST_UPDATED_BY = l_last_updated_by,
270: LAST_UPDATE_DATE = l_last_update_date,
271: LAST_UPDATE_LOGIN = l_last_update_login

Line 274: --Update OKL_LEASE_OPPS_ALL_B for references of Vendor

270: LAST_UPDATE_DATE = l_last_update_date,
271: LAST_UPDATE_LOGIN = l_last_update_login
272: WHERE SUPPLIER_ID = p_dup_vendor_id;
273:
274: --Update OKL_LEASE_OPPS_ALL_B for references of Vendor
275: UPDATE OKL_LEASE_OPPS_ALL_B
276: SET ORIGINATING_VENDOR_ID = p_vendor_id,
277: LAST_UPDATED_BY = l_last_updated_by,
278: LAST_UPDATE_DATE = l_last_update_date,

Line 275: UPDATE OKL_LEASE_OPPS_ALL_B

271: LAST_UPDATE_LOGIN = l_last_update_login
272: WHERE SUPPLIER_ID = p_dup_vendor_id;
273:
274: --Update OKL_LEASE_OPPS_ALL_B for references of Vendor
275: UPDATE OKL_LEASE_OPPS_ALL_B
276: SET ORIGINATING_VENDOR_ID = p_vendor_id,
277: LAST_UPDATED_BY = l_last_updated_by,
278: LAST_UPDATE_DATE = l_last_update_date,
279: LAST_UPDATE_LOGIN = l_last_update_login