DBA Data[Home] [Help]

APPS.INV_LOT_TRX_VALIDATION_PUB dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 1600: FROM wms_license_plate_numbers

1596: IF(p_st_lpn_id_tbl(i) IS NOT NULL) THEN
1597: BEGIN
1598: SELECT lpn_context
1599: INTO l_lpn_context
1600: FROM wms_license_plate_numbers
1601: WHERE lpn_id = p_st_lpn_id_tbl(i);
1602: EXCEPTION
1603: WHEN OTHERS THEN
1604: l_validation_status := 'N';

Line 1631: FROM wms_license_plate_numbers

1627: INTO l_lpn_context
1628: ,l_sub_code
1629: ,l_locator_id
1630: ,l_org_id
1631: FROM wms_license_plate_numbers
1632: WHERE lpn_id = p_rs_lpn_id_tbl(i);
1633: EXCEPTION
1634: WHEN OTHERS THEN
1635: l_validation_status := 'N';