DBA Data[Home] [Help]

APPS.CSP_SCH_INT_PVT dependencies on MTL_ONHAND_LOT_V

Line 3431: from MTL_ONHAND_LOT_V

3427: raise NO_DATA_FOUND ;
3428: END IF;
3429: begin
3430: select LOT INTO l_rsv_rec.lot_number
3431: from MTL_ONHAND_LOT_V
3432: where INVENTORY_ITEM_ID=p_reservation_parts.item_id
3433: and SUBINVENTORY_CODE = p_reservation_parts.sub_inventory_code
3434: and organization_id=p_reservation_parts.organization_id
3435: and rownum=1;