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 1144: FROM WMS_LICENSE_PLATE_NUMBERS wlpn

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