DBA Data[Home] [Help]

APPS.INV_TRANSFER_ORDER_PVT dependencies on MTL_LOT_NUMBERS

Line 4337: FROM mtl_lot_numbers

4333: -- Bug 8560030
4334: BEGIN
4335: SELECT reservable_type
4336: INTO l_reservable_type_lot
4337: FROM mtl_lot_numbers
4338: WHERE inventory_item_id = l_mtl_reservation_rec.inventory_item_id
4339: AND organization_id = l_mtl_reservation_rec.organization_id
4340: AND lot_number = l_mtl_reservation_rec.lot_number;
4341: EXCEPTION

Line 6273: FROM mtl_lot_numbers

6269: -- Bug 8560030
6270: BEGIN
6271: SELECT reservable_type
6272: INTO l_reservable_type_lot
6273: FROM mtl_lot_numbers
6274: WHERE inventory_item_id = l_mtl_reservation_rec.inventory_item_id
6275: AND organization_id = l_mtl_reservation_rec.organization_id
6276: AND lot_number = l_mtl_reservation_rec.lot_number;
6277: EXCEPTION