DBA Data[Home] [Help]

APPS.MTL_CCEOI_ACTION_PUB dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 1204: FROM WMS_LICENSE_PLATE_NUMBERS

1200:
1201: -- Check for LPN subinventory discrepancy
1202: SELECT subinventory_code, locator_id
1203: INTO l_sub, l_loc_id
1204: FROM WMS_LICENSE_PLATE_NUMBERS
1205: WHERE lpn_id = l_lpn.lpn_id
1206: AND organization_id = p_interface_rec.organization_id;
1207:
1208: IF p_interface_rec.subinventory <> l_sub OR p_interface_rec.locator_id <> l_loc_id THEN

Line 1291: FROM wms_license_plate_numbers

1287: BEGIN
1288:
1289: SELECT lpn_context
1290: INTO l_lpn_context
1291: FROM wms_license_plate_numbers
1292: WHERE lpn_id = p_interface_rec.parent_lpn_id;
1293:
1294: IF l_lpn_context = 5 THEN
1295: