APPS.WMS_PURGE_PVT dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 65: FROM WMS_LICENSE_PLATE_NUMBERS wlpn, WMS_TXN_CONTEXT_TEMP wtct

61:
62: l_progress := 'Filter out LPNs not valid for purge';
63: SELECT lpn_id BULK COLLECT
64: INTO l_valid_lpns
65: FROM WMS_LICENSE_PLATE_NUMBERS wlpn, WMS_TXN_CONTEXT_TEMP wtct
66: WHERE wtct.txn_source_name = 'WMS_LPN_PURGE'
67: AND wlpn.lpn_id = wtct.line_id
68: AND wlpn.lpn_context IN (4, 5)
69: AND NOT EXISTS ( SELECT 1 FROM MTL_TRANSACTIONS_INTERFACE

Line 83: AND NOT EXISTS ( SELECT 1 FROM WMS_LICENSE_PLATE_NUMBERS

79: AND parent_lpn_id = wlpn.lpn_id
80: AND entry_status_code = 2 )
81: AND NOT EXISTS ( SELECT 1 FROM MTL_ONHAND_QUANTITIES_DETAIL
82: WHERE lpn_id = wlpn.lpn_id )
83: AND NOT EXISTS ( SELECT 1 FROM WMS_LICENSE_PLATE_NUMBERS
84: WHERE outermost_lpn_id = wlpn.outermost_lpn_id
85: AND lpn_context <> wlpn.lpn_context)
86: FOR UPDATE;
87:

Line 200: DELETE FROM WMS_LICENSE_PLATE_NUMBERS

196: END IF;
197:
198: l_progress := 'Delete the LPN itself';
199: FORALL i IN p_lpn_id_table.first..p_lpn_id_table.last
200: DELETE FROM WMS_LICENSE_PLATE_NUMBERS
201: WHERE lpn_id = p_lpn_id_table(i);
202:
203: IF ( p_purge_count.exists(4) ) THEN
204: p_purge_count(4) := NVL(p_purge_count(4), 0) + SQL%ROWCOUNT;

Line 263: FROM WMS_LICENSE_PLATE_NUMBERS wlpn

259: l_wsh_lpn_rec WSH_GLBL_VAR_STRCT_GRP.purgeInOutRecType;
260:
261: CURSOR LPNS_FOR_PURGE IS
262: SELECT lpn_id
263: FROM WMS_LICENSE_PLATE_NUMBERS wlpn
264: WHERE organization_id = p_orgid
265: AND lpn_context IN (4, 5)
266: AND last_update_date < l_date;
267:

Line 294: l_purge_count(4) := 0; -- WMS_LICENSE_PLATE_NUMBERS

290: -- initialize table delete count variables
291: l_purge_count(1) := 0; -- WMS_PACKAGING_HIST
292: l_purge_count(2) := 0; -- WMS_LPN_HISTORIES
293: l_purge_count(3) := 0; -- WMS_LPN_CONTENTS
294: l_purge_count(4) := 0; -- WMS_LICENSE_PLATE_NUMBERS
295: l_purge_count(5) := 0; -- WMS_EPC
296:
297: OPEN LPNS_FOR_PURGE;
298:

Line 419: FND_MESSAGE.SET_TOKEN('TABLE','WMS_LICENSE_PLATE_NUMBERS');

415: FND_MSG_PUB.ADD;
416:
417: FND_MESSAGE.SET_NAME('INV','INV_TOTAL_ROWS');
418: FND_MESSAGE.SET_TOKEN('ROWS', l_purge_count(4));
419: FND_MESSAGE.SET_TOKEN('TABLE','WMS_LICENSE_PLATE_NUMBERS');
420: FND_MSG_PUB.ADD;
421:
422: FND_MESSAGE.SET_NAME('INV','INV_TOTAL_ROWS');
423: FND_MESSAGE.SET_TOKEN('ROWS', l_purge_count(5));

Line 459: AND EXISTS ( SELECT 1 FROM wms_license_plate_numbers wlpn

455: IF ( p_purge_type = EPC OR p_purge_type IS NULL ) THEN
456:
457: delete wms_epc we
458: where creation_date < sysdate --No organization is here
459: AND EXISTS ( SELECT 1 FROM wms_license_plate_numbers wlpn
460: WHERE wlpn.lpn_id = we.lpn_id
461: AND we.cross_ref_type = 1 --LPN-EPC
462: AND wlpn.lpn_context = 4 )
463: OR EXISTS ( SELECT 1 FROM mtl_serial_numbers msn