DBA Data[Home] [Help]

APPS.WMS_PICKING_PKG dependencies on MTL_SYSTEM_ITEMS_B

Line 631: FROM mtl_system_items_b

627: SELECT serial_number_control_code
628: , lot_control_code
629: INTO l_serial_number_control_code
630: , l_lot_control_code
631: FROM mtl_system_items_b
632: WHERE inventory_item_id = l_inventory_item_id
633: AND organization_id = l_org_id;
634:
635: IF (l_debug = 1) THEN

Line 4370: FROM mtl_system_items_b

4366: SELECT lot_control_code ,
4367: serial_number_control_code
4368: INTO l_lot_control_code ,
4369: l_serial_control_code
4370: FROM mtl_system_items_b
4371: WHERE inventory_item_id = l_mmtt_inventory_item_id
4372: AND organization_id = l_mmtt_organization_id;
4373: x_lot_control_code := l_lot_control_code;
4374: x_serial_control_code := l_serial_control_code;