DBA Data[Home] [Help]

APPS.INV_LOT_TRX_VALIDATION_PUB dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 1536: FROM wms_license_plate_numbers

1532: IF(p_st_lpn_id_tbl(i) IS NOT NULL) THEN
1533: BEGIN
1534: SELECT lpn_context
1535: INTO l_lpn_context
1536: FROM wms_license_plate_numbers
1537: WHERE lpn_id = p_st_lpn_id_tbl(i);
1538: EXCEPTION
1539: WHEN OTHERS THEN
1540: l_validation_status := 'N';

Line 1567: FROM wms_license_plate_numbers

1563: INTO l_lpn_context
1564: ,l_sub_code
1565: ,l_locator_id
1566: ,l_org_id
1567: FROM wms_license_plate_numbers
1568: WHERE lpn_id = p_rs_lpn_id_tbl(i);
1569: EXCEPTION
1570: WHEN OTHERS THEN
1571: l_validation_status := 'N';