APPS.WMS_TASK_UTILS_PVT dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 528: FROM wms_license_plate_numbers

524: IF l_count = 0 THEN -- no more rows and the current row is the
525: --last allocation
526: BEGIN
527: SELECT lpn_context INTO l_lpn_context
528: FROM wms_license_plate_numbers
529: WHERE lpn_id = l_transfer_lpn_id;
530: EXCEPTION
531: WHEN no_data_found THEN
532: l_lpn_context := NULL;

Line 1147: FROM WMS_LICENSE_PLATE_NUMBERS wlpn

1143:
1144: --Bug#5984021.If LPN is empty, no need of stamping it on MMTT.
1145: IF ( NVL(mmtt_row.allocated_lpn_id , 0 ) > 0 ) THEN
1146: SELECT wlpn.lpn_context INTO l_lpn_ctx
1147: FROM WMS_LICENSE_PLATE_NUMBERS wlpn
1148: WHERE wlpn.lpn_id = mmtt_row.allocated_lpn_id ;
1149:
1150: IF (l_debug = 1) THEN
1151: mydebug('LPN id : '||mmtt_row.allocated_lpn_id ||', context:' || l_lpn_ctx );