DBA Data[Home] [Help]

APPS.WMS_PICKING_PKG dependencies on MTL_SYSTEM_ITEMS_B

Line 469: FROM mtl_system_items_b

465: SELECT serial_number_control_code
466: , lot_control_code
467: INTO l_serial_number_control_code
468: , l_lot_control_code
469: FROM mtl_system_items_b
470: WHERE inventory_item_id = l_inventory_item_id
471: AND organization_id = l_org_id;
472:
473: IF (l_debug = 1) THEN

Line 3942: FROM mtl_system_items_b

3938: SELECT lot_control_code ,
3939: serial_number_control_code
3940: INTO l_lot_control_code ,
3941: l_serial_control_code
3942: FROM mtl_system_items_b
3943: WHERE inventory_item_id = l_mmtt_inventory_item_id
3944: AND organization_id = l_mmtt_organization_id;
3945: x_lot_control_code := l_lot_control_code;
3946: x_serial_control_code := l_serial_control_code;